Using dbms_metadata to extract a full schema
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 30 Apr 2004 11:41:21 -0600
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
