You can write your own scripts to do this fairly easily. Oracle puts a lot of 
metadata into views to allow just this sort of thing. all_tab_columns, 
user_tab_columns, user_sequences, user_indexes etc. Here's a page with a 
complete listing: 
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96536/index.htm

-----Original Message-----
From: Michael Nhan [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 11:15 AM
To: Steve Sapovits
Cc: [email protected]
Subject: Re: Oracle schema comparison


Hi,

Look into Toad by quest software.  It has a schema comparison tool.

Regards,
Michael

> Date: Thu, 16 Jun 2005 11:11:12 -0400
> From: Steve Sapovits <[EMAIL PROTECTED]>
> To: [email protected]
> Subject: Oracle schema comparison
> 
>
> Does anybody know of any good tools (free or otherwise) for comparing
> two Oracle schemas?  I'd want to be able to compare tables, indices,
> sequences, etc. to see what one has and another doesn't.  In an ideal
> world I'd also be able to compare the actual data in the tables, but
> the primary need is to be able to see if tables and indices match.
>
>

                ---//---
     "He who learns must suffer. And even in our sleep,
  pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,
  comes wisdom to us by the awful grace of God."
                --- Aeschylus

Reply via email to