by Mark D Powell <Mark.Powell@[EMAIL PROTECTED]
>
Apr 2, 2008 at 07:52 AM
On Apr 1, 6:59=A0pm, AgataKrishtoff <agata0krisht...@[EMAIL PROTECTED]
> wrote:
> Dear All,
>
> Is anyone aware of a way to compare Oracle databases (schemas and
> content)? I found a .net software DBTyP.net that promises an easy and
> visual comparison, but it seems not to be working with Oracle dbs
> (though their site outlines it as one of the available options).
>
> Thank you.
> Agata
I once wrote a routine to compare the contents of a table loaded with
the contents of dba_tab_columns from multiple databases. You could do
the same.
Tom Kyte has written about comparing tables to find differences so you
can probably find an article on this at http://asktom.oracle.com
via
the search feature there.
select * from tableA minus select * from TableA@[EMAIL PROTECTED]
-- Mark D Powell --
