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

Home -> Community -> Usenet -> c.d.o.server -> Capture of DDL Statement

Capture of DDL Statement

From: Jerry Metz <JMetz1_at_ix.netcom.com>
Date: Sun, 17 Mar 2002 21:25:32 GMT
Message-ID: <3C9509CC.646536E0@ix.netcom.com>


I want to be able to capture in a database trigger all of the changes made to the database schemas by any and all users. As a part of that, I can get the user_id, the object name, object type, and schema with no problem via sys.dictionary_obj...

I am running both Oracle9i and Oracle8i Enterprise (on separate machines).

Does anyone have any ideas on how to capture the actual ddl statement (either before or after it is sent to the database)?

PS - I've looked in all of the manuals that I have, so, if you are going to send me back to the manuals for further reference checking, please point me to the appropriate manual to look at. Thanks.


Received on Sun Mar 17 2002 - 15:25:32 CST

Original text of this message

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