Hi there There was a article on asktom.oracle.com a while back of a stored procedure/trigger extension you can add to Oracle with a logging table that record when a table was added or modified or basically any object was altered.
George __________________________________________ George Leonard Oracle Database Administrator Professional Services (Oracle Business Unit) Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -----Original Message----- [EMAIL PROTECTED] Sent: 04 December 2003 04:49 PM To: Multiple recipients of list ORACLE-L Hi List, Does anyone use Change Manager software to keep track of the changes that went into the database. We have 25 environments and having difficult time to keep track of the changes between different release(version) within the same database and same release across different database. For example, In an ideal manner we would like to know something like Table name t1 has been added between Rel1.1 and Rel1.2 Procedure P1 got changed between Rel1.1 and Rel1.2 Existing view V1 has been altered between these rel Any suggestions? Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). �This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp " -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: George Leonard INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
