RE: Change Manager

From: George Leonard <leonarge_at_vodacom.co.za>
Date: Sun, 07 Dec 2003 22:49:25 -0800
Message-ID: <F001.005D91F6.20031207224925@fatcity.com>

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:george.leonard_at_za.didata.com
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-----
jaysingh1_at_optonline.net
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: jaysingh1_at_optonline.net

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: ListGuru_at_fatcity.com (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: leonarge_at_vodacom.co.za

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------