Hi the Change Management pack is nice but it records changes by way of comparing schemas, IE it is reactive. Take baseline snapshot. change 1 made on object A change 2 made on object A Change Management- snapshot taken. now it only shows the difference between base line and Change 2, it does = not know about change 1. and it is dependant on the regular snapshots taken. George =20________________________________________________ George Leonard Oracle Database Administrator New Dawn Technologies @ Wesbank E-mail:gleonard@xxxxxxxxxxxxx =20 You Have The Obligation to Inform One Honestly of the risk, And As a Pers= on You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk,=20 Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -----Original Message----- From: Mogens N=F8rgaard [mailto:mln@xxxxxxxxxxxx] Sent: Monday, July 12, 2004 12:39 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Capturing Schema changes ?? One last suggestion, and then I'll be quiet on this topic :) - Can OEM's = Change Management Pack do this? Mogens Leonard, George wrote: > Hi all >=20 > Some clearing up of requirements. >=20 > We are currently looking at source control/document management software= =20to > start tying up the different development/testing and then finally production > environments together to display the creation and evolvement of process= es. >=20 > Although we have very very few people making changes in production we w= ant > to be able to track changes since sometimes during the night we have a > emergency and code gets changed to get a process/batch to complete. >=20 > And as with all humans this sometimes evade the responsible person from= > informing where required. >=20 > So one the one side we want something independent of human interaction = to > notify us that something was changed but we further want the before cha= nge > version. >=20 > SO in summary, the DDL trigger option is high up the solution list. >=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- _________________________________________________________________________= __________________________ The views expressed in this email are, unless otherwise stated, those of = the author and not those of the FirstRand Banking Group or its management. The information in thi= s e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone= =20else is unauthorised.=20 If you are not the intended recipient, any disclosure, copying, distribut= ion or any action taken or=20 omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrit= y of information and data=20 transmitted electronically and to preserve the confidentiality thereof, n= o liability or=20 responsibility whatsoever is accepted if information or data is, for what= ever reason, corrupted=20 or does not reach its intended destination. =20 ________________________________ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------