RE: Using dbms_metadata to extract a full schema

  • From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 30 Apr 2004 14:48:10 -0400

I'll send you a package.   It's not complete yet but the table, index, =
constraints, triggers, object grants, materialized views extraction =
works fine.  I'm having trouble with the procedure that extracts source: =
packages, procedures, functions, sequences.  I'm getting a value error =
on *SOME* of the objects and can't figure out what is wrong with it.  =
I've been working on this problem for about a week.  Any case, if you =
want to adapt it to your needs go ahead.  If anybody else wants it you =
can contact me at dofreeman@xxxxxxxxxxxx

=20
> Yes, I know I can use exp w/rows=3DN to do the same thing, but I
> am trying to learn something new.=20
>=20
> Any examples, docs, etc. are greatly appreciated.
----------------------------------------------------------------
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: