Just faulty memory (mine) On 6/13/07, Baumgartel, Paul <paul.baumgartel@xxxxxxxxxxxxxxxxx> wrote:
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> 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://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 ==============================================================================
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist