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
Messages: 46
Registered: July 2006
Location: CA
Dear all

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

Re: Table Transactions (Type &Time) [message #225214 is a reply to message #225209] Mon, 19 March 2007 03:12 Go to previous message
Messages: 21146
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: Fri Aug 18 03:52:31 CDT 2017

Total time taken to generate the page: 0.11942 seconds