OraFAQ Forum: Replication » Oracle Log of DML Commands

Home » Server Options » Replication » Oracle Log of DML Commands

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Oracle Log of DML Commands [message #240036]

Thu, 24 May 2007 00:23

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

Report message to a moderator

Re: Oracle Log of DML Commands [message #240294 is a reply to message #240036]

Thu, 24 May 2007 10:05

Littlefoot
Messages: 16980
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You might enable auditing.

Report message to a moderator

Re: Oracle Log of DML Commands [message #240882 is a reply to message #240294]

Sun, 27 May 2007 03:35

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

Report message to a moderator

Previous Topic:	Clarification for Replication
Next Topic:	MATERIALIZED VIEW on XMLDATATYPE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 20:02:04 CDT 2013

Total time taken to generate the page: 0.20573 seconds