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 -> Re: Whats the best way to see what changes have been made to a database structure?

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

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 20 Feb 2005 15:09:54 -0800
Message-ID: <1108940816.183789@yasure>


deanbrown3d_at_yahoo.com wrote:

> 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

Institute a change management process and fire anyone that violates it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Feb 20 2005 - 17:09:54 CST

Original text of this message

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