| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: comparison tools...
I use TOAD with the DBA option. It does an excellent job except for comparing ROLEs and finding privileges granted by someone other than the object owners (you can find that 2nd class of privileges --- you just have to know that they exist and go look for them).
This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
"Thater,
William" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
<William.Thater cc:
@carrier.utc.com Subject: comparison tools...
>
Sent by: root
05/12/2003 12:01
PM
Please respond
to 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: Thomas Day INET: tday6_at_csc.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).Received on Mon May 12 2003 - 11:37:37 CDT
 |
 |