Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to compare two instances ?

Re: How to compare two instances ?

From: Buck Turgidson <george_at_whitehouse.gov>
Date: Sat, 15 Sep 2001 11:20:54 GMT
Message-ID: <qQGo7.285386$J37.74390795@typhoon.southeast.rr.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US