Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Version control of Oracle Stored Objects.

Re: Version control of Oracle Stored Objects.

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 05 Mar 2005 23:37:54 GMT
Message-ID: <Xns96109F035CDF1SunnySD@68.6.19.6>


DA Morgan <damorgan_at_x.washington.edu> wrote in news:1110065133.857196_at_yasure:
> The real BDFH builds a DDL trigger that raises an exception with all DDL
> on the database and another that audits it. He/she then disables the
> first trigger whenever making changes leaving the second one to create
> the audit trail.

Alternatively, just nightly extract the current production code from the repository and install it into the database. Any and all ad hoc, on the fly or unapproved changes just get summarily overwritten. Received on Sat Mar 05 2005 - 17:37:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US