On Apr 2, 8:52 am, Mark D Powell <Mark.Pow...@[EMAIL PROTECTED]
> wrote:
> On Apr 1, 6:59 pm, 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 athttp://asktom.oracle.comvia
> the search feature there.
>
> select * from tableA minus select * from TableA@[EMAIL PROTECTED]
>
> HTH -- Mark D Powell --
I just found Tom Kyte's site (sorry, I am a novice, seems that
everyone else but me knows it ;)). Thank you for the ref!
|
