Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to compare two instances ?
In addition to comparing objects as the other poster suggested, you
could analyze both databases, compute statistics, then compare
NUM_ROWS in DBA_TABLES.
"Davide Bianchi" <davidebianchi_at_davidebianchi.net> wrote in message
news:9nsutp$9l4ta$1_at_ID-18487.news.dfncis.de...
> I have two instances of Oracle 8.1.7, let's call them
> A and B. The two instances are supposedly identical.
> An application using instance A spit out a trackload
> of errors, the same application (note: the same code,
> not another copy) using instance B run fine...
>
> So, something in the A instance get screwed... the
> problem is what ??? How can I compare the two
> instances (without spending a trackload of money
> for specialized tools) ?
>
> Davide
>
>
>
Received on Sat Sep 15 2001 - 06:20:54 CDT