Re: SCHEMA_EXPORT with DBMS_METADATA

Henry,

I modified my code to reflect your approach and I'm now getting all of the DDL--thanks again! I modeled my original code on some working code that gets dependent DDL (*that* was modeled on something I found on the Net), but it wasn't right for a schema export. My modified code gets one DDL per object, which is fine--now I want to set parse items to get object type and object name for each one. Hopefully I'll get that working and then post it to the list.

Regards,

Paul

On 1/20/06, Henry Poras <henry_at_itasoftware.com> wrote:
>
> Paul,
>
> Here is a rough script I wrote for this. Haven't used it too much, but it
> might help.
>
> Henry Poras
>
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Paul Baumgartel
> *Sent:* Thursday, January 19, 2006 7:21 PM
> *To:* Oracle-L
> *Subject:* SCHEMA_EXPORT with DBMS_METADATA
>
> Has anyone successfully used DBMS_METADATA's SCHEMA_EXPORT capability to
> generate DDL for all schema objects? If so, please let me know; perhaps
> you'll be good enough to take a look at my code and tell me what I'm doing
> wrong. I have a TAR..er, SR, open with Oracle but as usual the analyst is
> clueless. Thanks.
>
> --
> Paul Baumgartel
> paul.baumgartel_at_aya.yale.edu
>
>
>

--
Paul Baumgartel
paul.baumgartel_at_aya.yale.edu

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