Re: comparison tools...

Thanks Mark

I also saved this.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, May 12, 2003 6:32 PM

> Bill,
>
> You can use TOAD Freeware version to compare two schemas (View/Schema
> Differences menu).
>
> As for table data, here's a script that I found once through a google
search
> that worked pretty well:
>
> http://www.uaex.edu/srea/comptables.sql
>
> HTH
>
> Mark
>
> -----Original Message-----
> William
> Sent: 12 May 2003 17:02
> To: Multiple recipients of list ORACLE-L
>
>
> OK, they have this document management system here installed on 4
databases,
> dev, staging, and 2 prod instances. they have a master production and a
> slave production at two different locations. the "slave" is what's used
to
> serve out the documents to the web customers. any changes are made on the
> master and then replicated out. so do they use Oracle replication?
> ummmm... or do they use the document management system's replication that
> fails at odd times and never reports errors? guess....
>
> so now they want to compare the contents of the two production instances
to
> see what is or is not the same between them. so does anybody know of a
tool
> to compare the contents of two schemas? or even to compare the outputs of
a
> query against the two schemas? [other than the obvious "save it to a file
> and run diff" one?;-)]
>
> www.mailfiler.com [BT-G5DM8]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thater, William
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mark Leith
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).