Re: Sql Developer

Just faulty memory (mine)

On 6/13/07, Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com> 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_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> 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

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