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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 19 Feb 2005 09:35:38 +0100
Message-ID: <3hud11l2vbqts68goq4tmmhijnd4j17h66@4ax.com>


On 18 Feb 2005 13:40:20 -0800, "deanbrown3d_at_yahoo.com" <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

The best way to deal with this is to have a proper development process in place, source code control, and a beating for those people who continue to change the database on the fly.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Feb 19 2005 - 02:35:38 CST

Original text of this message

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