Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Whats the best way to see what changes have been made to a database structure?

Whats the best way to see what changes have been made to a database structure?

From: <deanbrown3d_at_yahoo.com>
Date: 18 Feb 2005 13:40:20 -0800
Message-ID: <1108762820.683244.94030@l41g2000cwc.googlegroups.com>


Hi there,

Our small company regularly alters tables, creates new views, adds triggers and sequences, and these changes have to be reciprocated at out (single) client site. Its hard to keep track, as people forget the changes they have made, or don't bother to update files of changes.

What's the best way to compare 2 different schemas in a single database? Something that will tell me things like:

  1. This table T1 has a new fields...
  2. This table T2 does not exist...
  3. This table T3 has a different key...
  4. This view is different.
  5. This trigger is changed.
  6. This sequence is new. etc....

Thanks for any help,

Dean Received on Fri Feb 18 2005 - 15:40:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US