Home » SQL & PL/SQL » SQL & PL/SQL » How to track DML operations (Oracle 9i,Windows)
How to track DML operations [message #337559] Thu, 31 July 2008 04:27 Go to next message
koteshwar
Messages: 7
Registered: October 2006
Location: hyderabad
Junior Member
Hi,

Please tell me how to track all DML operations done on
Oracle 9i Database.
Thanks in Advance.

Regards
Koteshwar.
Re: How to track DML operations [message #337563 is a reply to message #337559] Thu, 31 July 2008 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Audit
LogMiner
Table monitoring (dba_tab_modifications)
depends on what you need.

Regards
Michel
Re: How to track DML operations [message #337578 is a reply to message #337563] Thu, 31 July 2008 05:26 Go to previous messageGo to next message
koteshwar
Messages: 7
Registered: October 2006
Location: hyderabad
Junior Member
Hi,

Thanks for replying,can u please tell me
How to audit for the database(on all tables).

Regards
Koteshwar T
Re: How to track DML operations [message #337579 is a reply to message #337578] Thu, 31 July 2008 05:31 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Audit each table one by one.

Regards
Michel
Previous Topic: ORA-04067 clob2blob procedure error
Next Topic: Performance Issue
Goto Forum:
  


Current Time: Fri Dec 09 11:39:42 CST 2016

Total time taken to generate the page: 0.15791 seconds