| 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: How to compare two schemas
If you have OEM- change management pack. Then this is would be easy. The
pack has a DB Diff option which provides comaprision of schemas /objects
between two databases etc.
Murali Vallath
Oracle Certified - DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerskyus.com/
From: "Helmut Daiminger" <hdaiminger_at_vivonet.com>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Subject: How to compare two schemas
Date: Thu, 30 Nov 2000 14:29:02 -0800
Hi there!
We have the same schema on the production and the development box.
How can I compare all tables (and their columns) in those two schemas and confirm that they match?
I just want to compare the tables (and their columns). I don't care about data in the tables.
Any ideas?
This is 8.1.6 on Win2k.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
INET: hdaiminger_at_vivonet.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |