Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!lnsnews.lns.cornell.edu!paradoxa.ogoense.net!sn-xit-04!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: "Steve Ashmore" Newsgroups: comp.databases.oracle.server Subject: Re: How to monitor schema changes Date: Thu, 6 Jun 2002 18:26:28 -0500 Organization: Posted via Supernews, http://www.supernews.com Message-ID: References: <43lvfuo2shp4rhj2p25nbn2cq38th1m21c@4ax.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Complaints-To: newsabuse@supernews.com Lines: 38 Xref: easynews comp.databases.oracle.server:149810 X-Received-Date: Thu, 06 Jun 2002 16:23:54 MST (news.easynews.com) The LAST_DDL_TIME column in dba_objects will show you which object has changed. I would suggest you arrange to have the developers rights removed from the production system. It is not good practice to let people modift objects in a production system. As Sharon states: Change control... Stephen C. Ashmore Brainbench MVP for Oracle Administration http://www.brainbench.com Author of: 'So You Want to be an Oracle DBA?' "Rick Denoire" <100.17706@germanynet.de> wrote in message news:43lvfuo2shp4rhj2p25nbn2cq38th1m21c@4ax.com... > 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