Home » SQL & PL/SQL » SQL & PL/SQL » DML statements notification
DML statements notification [message #280833] Wed, 14 November 2007 23:41 Go to next message
sumesh0710
Messages: 2
Registered: November 2007
Junior Member
Hello,
I have about 300 tables in my database, which is in oracle 9i. If any DML statements are done on these tables, I need a notification like, inserts a row to a notification table or creates a notification file. Writting trigger on all these tables is not possible. Is there are any other ways??
Re: DML statements notification [message #280835 is a reply to message #280833] Wed, 14 November 2007 23:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
AUDIT
Re: DML statements notification [message #280836 is a reply to message #280835] Wed, 14 November 2007 23:51 Go to previous messageGo to next message
sumesh0710
Messages: 2
Registered: November 2007
Junior Member
THANKS for quick reply.
AUDIT? can you please explain a little..
Re: DML statements notification [message #280837 is a reply to message #280833] Wed, 14 November 2007 23:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Are you incapable or unwilling to use GOOGLE or search this forum?
Re: DML statements notification [message #280851 is a reply to message #280836] Thu, 15 November 2007 00:50 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
AUDIT

Regards
Michel
Previous Topic: query Hierarchical data
Next Topic: PLS-00201: identifier 'procedure' must be declared
Goto Forum:
  


Current Time: Thu Feb 06 14:33:47 CST 2025