RE: Sql Developer

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_at_credit-suisse.com
www.credit-suisse.com  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Wednesday, June 13, 2007 12:42 PM
To: ddavey_at_harris.com
Cc: oracle-l_at_freelists.org
Subject: Re: Sql Developer

On 6/13/07, Davey, Alan <ddavey_at_harris.com <mailto:ddavey_at_harris.com> > 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


==============================================================================



--
http://www.freelists.org/webpage/oracle-l