Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBMS_????? that does schema compare

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US