Re: Using dbms_metadata to extract a full schema

From: <jtesta_at_dmc-it.com>
Date: Fri, 30 Apr 2004 14:10:33 -0400 (EDT)
Message-ID: <65017.155.188.191.5.1083348633.squirrel@www.dmc-it.com>

I've had to do it in batches, ie: all the tables, then all of the indexes, then all of the sequences.

I've not gotten around to building a front-end wrapper to be able to do them all at one time.

joe

*ORIGINAL MESSAGE BELOW * Okay, I've rtfmed, ctnomed, googled and I'm still not finding anything close.

I want to use dbms_metadata to extract all the objects associated with a specific schema. Every article I find that says "Here's how you extract a schema" shows how to extract multiple tables and, sometimes, indexes. Unfortunately, the schema I'm looking at has triggers, sequences, etc. Even the Oracle documentation examples cover multiple tables though they say that they are extracting a schema.

Yes, I know I can use exp w/rows=N to do the same thing, but I am trying to learn something new.

Any examples, docs, etc. are greatly appreciated.

Daniel

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Apr 30 2004 - 14:16:59 CDT