Home » SQL & PL/SQL » SQL & PL/SQL » Table Transactions (Type &Time)
Table Transactions (Type &Time) [message #225209] Mon, 19 March 2007 02:56 Go to next message
alzuma
Messages: 46
Registered: July 2006
Location: CA
Member
Dear all

i want know the last transaction time (insert - update - delete)
occurs on certain table in my schema ? how ?

Thanks
Re: Table Transactions (Type &Time) [message #225214 is a reply to message #225209] Mon, 19 March 2007 03:12 Go to previous message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Enable auditing or create a database trigger which will take care about it. Similar question was already asked here; search for more detailed answers (at least, now you know the keywords).
Previous Topic: 10g XE - Script Editor not behaving in Firefox ??
Next Topic: Interesting Query
Goto Forum:
  


Current Time: Mon Dec 05 08:34:21 CST 2016

Total time taken to generate the page: 0.13388 seconds