Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Version control of Oracle Stored Objects.
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
![]() |
![]() |