Home » RDBMS Server » Server Administration » Keep log statement (oracle9i with windows2003)
icon5.gif  Keep log statement [message #349515] Mon, 22 September 2008 02:23 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

Is there any ways to keep log sql statement after insert,update,delete as the example below :

=========================================================
user01 client01 prog01.exe update emp set name='test';
user02 client02 prog02.exe delete from emp1;

I 'm not sure.Can use trigger? Is anybody have the example code?

Thank you for advance
Chara
Re: Keep log statement [message #349528 is a reply to message #349515] Mon, 22 September 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is called AUDIT.

Regards
Mighel
icon5.gif  Re: Keep log statement [message #349539 is a reply to message #349528] Mon, 22 September 2008 02:53 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Thank you for your replied.I saw yrs document for oracle10g.
But my db is oracle9i.Can it use?

Regards,
Chara
Re: Keep log statement [message #349544 is a reply to message #349539] Mon, 22 September 2008 03:08 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'd say you can have a look at 9i documentation for the same.
Audit existed since so many versions that I can't remember.

Regards
Michel
Previous Topic: ORA-00020: maximum number of processes (150) exceeded
Next Topic: ora-04031 while generating server alert smg-3503
Goto Forum:
  


Current Time: Fri Dec 09 08:03:21 CST 2016

Total time taken to generate the page: 0.13372 seconds