Re: Sql Developer

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

Other related posts: