We do a simple method of checking the LAST_DDL_TIME in DBA_OBJECTS. This
will give a decent indication of at least what objects have changed ....
just not neccessarily the actual change that was made. Along with this we
use a ADMINISTRATIVE log. When we make changes ...we update the log. This
is only good if YOUR DBAS UPDATE THE LOG. Another way is to require that
anyone making DDL change make a copy of the object first. This way you have
a before and after image. We have written a package that will generate the
DDL for most kind of objects (well, at least 7.3.4 and 8.0 objects) so that
we have the rebuild scripts for objects before changes.
Hope at least some of this helps.
-----Original Message-----
Sent: Tuesday, June 05, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
I'd appreciate any info. anyone could provide on what method you use to
track database changes that have been implemented in
dev, test, stage and production. I need a way of tracking frequent
modifications to tables, packages, etc.. and wanted to get some input on how
others are handling this.
TIA,
Richard Huntley
E-mail: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Huntley
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
