Oracle-L: RE: comparison tools...

From: Henry Poras <hporas_at_etal.uri.edu>
Date: Mon, 12 May 2003 08:57:37 -0800
Message-ID: <F001.00596DFA.20030512085737@fatcity.com>

data differences or schema differences?

-----Original Message-----
William
Sent: Monday, May 12, 2003 12:02 PM
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: Henry Poras
  INET: hporas_at_etal.uri.edu

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).

Received on Mon May 12 2003 - 11:57:37 CDT