Re: DBMS_????? that does schema compare

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: Tue, 16 May 2006 12:53:33 -0700 (PDT)
Message-ID: <20060516195333.32242.qmail@web37212.mail.mud.yahoo.com>

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_at_gmail.com> 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).

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 16 2006 - 14:53:33 CDT