Re: DBMS_????? that does schema compare
- From: Daniel Fink <danielwfink@xxxxxxxxx>
- To: sol.beach@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 May 2006 12:53:33 -0700 (PDT)
There is an OEM pack that does this as well as some 3rd party tools (I think
Quest has one), but I don't recall seeing a supplied package that did this.
You could use dbms_metadata to extract all the objects for the two schemas then
run a diff on the files.
Regards,
Daniel Fink
sol beach <sol.beach@xxxxxxxxx> wrote: I'm having a senior moment.
I would have sworn that an Oracle supplied DBMS_* package exists which
compares two schemas.
If it exists, whatis its name?
TIA
P.S.
I have googled, searched both Metalink & OTN & have struck out (so far).
Other related posts:
