RE: comparison tools...

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: William.Thater_at_carrier.utc.com

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: ListGuru_at_fatcity.com (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: mark_at_cool-tools.co.uk

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: ListGuru_at_fatcity.com (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).