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