Home » Server Options » Replication » Oracle Log of DML Commands
Oracle Log of DML Commands [message #240036] Thu, 24 May 2007 00:23 Go to next message
Sabeen
Messages: 25
Registered: March 2005
Location: Pakistan
Junior Member
Hi,

Anyone knows that where oracle maintain log of DML operations on any schema.

we can keep track of DML operations with triggers,


but i want to know, whether oracle itself maintain log of DML operations or not..


thanx
Re: Oracle Log of DML Commands [message #240294 is a reply to message #240036] Thu, 24 May 2007 10:05 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You might enable auditing.
Re: Oracle Log of DML Commands [message #240882 is a reply to message #240294] Sun, 27 May 2007 03:35 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
YES oracle would maintains log of DMLs only if you enable Fined grained auditing on those tables for which you wanna captures logs.

DBMS_FGA package.
http://www.psoug.org/reference/dbms_fga.html
Previous Topic: Clarification for Replication
Next Topic: MATERIALIZED VIEW on XMLDATATYPE
Goto Forum:
  


Current Time: Thu Mar 28 08:45:48 CDT 2024