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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to monitor schema changes

Re: How to monitor schema changes

From: Sharon <Sharon_at_kipnuk.marinliving.net>
Date: Thu, 06 Jun 2002 15:12:45 -0700
Message-ID: <3CFFDE5D.2C32C3C7@kipnuk.marinliving.net>


I would suggest something called change control

Rick Denoire wrote:

> Hello
>
> Users complain to the DB administrator (me) when the DB developer has
> changed the DB schema so that the SQL queries don't work anymore.
>
> Is there a way to monitor changes in the DB schema? I mean when tables
> or views are renamed, columns are deleted, etc.
>
> I thought that doing an export with the option rows=no and comparing
> this output (which contains all ddl commands) with further similar
> exports should reveal any changes.
>
> In general, what is the best practice in order to avoid this kind of
> problems caused by changes in the DB schema? (Supposing that such
> changes are absolutely necessary).
>
> Thanks
> Rick
Received on Thu Jun 06 2002 - 17:12:45 CDT

Original text of this message

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