Re: Comparing databases (Oracle, etc.)

On Apr 2, 8:52 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Apr 1, 6:59 pm, AgataKrishtoff <agata0krisht..._at_gmail.com> 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_at_databaseB
>
> 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! Received on Wed Apr 02 2008 - 12:29:18 CDT