Re: SCHEMA_EXPORT with DBMS_METADATA
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: Henry Poras <henry@xxxxxxxxxxxxxxx>
- Date: Fri, 20 Jan 2006 18:46:53 -0500
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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@xxxxxxxxxxxx
>
>
>
--
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxx
Other related posts:
