RE: Capturing Schema changes ??

From: Leonard, George <GLeonard_at_wesbank.co.za>
Date: Mon, 12 Jul 2004 12:54:20 +0200
Message-ID: <31779D7666D8D11181BC0000F6B2EF7A0B929D2E@krkmsg01.fnb.co.za>

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_at_wesbank.co.za
=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_at_miracleas.dk] Sent: Monday, July 12, 2004 12:39 PM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 12 2004 - 05:51:15 CDT