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: 25045
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: 25045
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: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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: Wed Dec 07 18:45:32 CST 2016

Total time taken to generate the page: 0.10077 seconds