RE: Sql Developer
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'jkstill@xxxxxxxxx'" <jkstill@xxxxxxxxx>
- Date: Wed, 13 Jun 2007 18:21:50 +0100
What's DBMS_METADATA_UTIL?
I've written a package that calls DBMS_METADATA (10g) to produce the DDL to
recreate an entire schema, and it works great. I can't find any reference in
the docs to DBMS_METADATA_UTIL.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jared Still
Sent: Wednesday, June 13, 2007 12:42 PM
To: ddavey@xxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Sql Developer
On 6/13/07, Davey, Alan <ddavey@xxxxxxxxxx <mailto:ddavey@xxxxxxxxxx> > wrote:
My biggest problem with SQL Developer compared to Toad is that the sql
formatter when used on pl/sql code sucks.
The folks mostly responsible for SQL-Developer are Kris Rice and Sue Harper.
Blogs:
http://krisrice.blogspot.com/ <http://krisrice.blogspot.com/>
http://sueharper.blogspot.com/ <http://sueharper.blogspot.com/>
They are well aware of problems with dbms_metadata_util.
They also have no power to fix it.
Seems rather strange that a package that is so potentially useful
has such a fatal flaw, and one that should be easily fixed.
For the un-initiated, DDL output from dbms_metadata_util always
needs to be reformatted before being used, making it rather useless
for anything large scale.
There are alternatives.
Taking an export of a schema and stripping out the SQL is do-able.
I've done so with Perl, though awk/sed/grep could do it as well.
Even better, if you use Perl, DDL::Oracle will pull DDL from the database,
and it doesn't require reformatting.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
