OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Keep log statement (oracle9i with windows2003)

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

Keep log statement [message #349515]

Mon, 22 September 2008 02:23

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

Report message to a moderator

Re: Keep log statement [message #349528 is a reply to message #349515]

Mon, 22 September 2008 02:39

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is called AUDIT.

Regards
Mighel

Report message to a moderator

Re: Keep log statement [message #349539 is a reply to message #349528]

Mon, 22 September 2008 02:53

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

Report message to a moderator

Re: Keep log statement [message #349544 is a reply to message #349539]

Mon, 22 September 2008 03:08

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 15:09:50 CST 2025