Re: Compare utility for Oracle databases

You also could take a look at:
http://www.bmc.com/products/pat/dm/pdbcm.html

This is about a tool called Patrol DB-Change Manager. You can make version off your data dictionary. Do comparisons between version and catalogs.

Ben

G.Reulen wrote:
>
> Lun Wing San <rdbms_at_hkstar.com> wrote:
>
> >Programming wrote:
> >>
> >> Are there similar utilities in Oracle, that will
> >> compare and point out the differences between:
> >> - tables from different databases
> >> - entire schemas from different databases
> >
> > You can write some scripts that query the data dictionary for comparison. However,
> >there is no such utility developed by Oracle so far.
> >
> Look at http://www.oramag.com/code/cod04257.html
>
> I thnk this what you want.
>
> G.Reulen
> G.Reulen_at_vir.revalidatie.nl
>
> >--
> >*****************************************************************************
> >* *
> >* Please go to http://www.hkstar.com/~rdbms/oracle.htm to find other solns *
> >* *
> >*****************************************************************************
> >
> >---
> >Name : Lun Wing San (Certified Oracle Database Administrator)
> >
> >Title : Oracle Database Administrator and System Administrator of QRC
> >Phone : (852)27885841
> >
> >This posting represents the personal opinions of the author. It is not the
> >official opinion or policy of the author's employer. Warranty expired when you
> >opened this article and I will not be responsible for its contents or use.
  Received on Wed May 14 1997 - 00:00:00 CDT