Re: Need comparison script.

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 03 Jun 1999 11:43:39 -0700
Message-ID: <3756CCDB.F357A6A@us.oracle.com>

Tim

The easiest way to do this is to use the Change Management pack in Enterprise Manager, which has a schema comparison utility. Otherwise, you could either:

Run scripts against each database that output the table structures to a file, then diff the files either manually or automagically at the OS level
Create a database link between the two databases, then do different select *'s from dd tables_at_one db minus select*'s from dd tables at the other db, and vice versa.

HTH. Pete

tim_mcconechy_at_my-deja.com wrote:

> How do I build a script to compare two instances which should
> be indentical...
> that is to compare all table structures of the tables with the same name
> and insure all the sam objects are in each schema.
>
> Surely someone out there has done this???
>
> TIA
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Regards

Pete

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Thu Jun 03 1999 - 13:43:39 CDT