| Last DML on a table [message #371876] |
Sat, 16 December 2000 02:03  |
Keshava
Messages: 1
Registered: December 2000
|
Junior Member |
|
|
|
Is there a way to get the last time a table's data was touched, by using Data Dictionary?
|
|
|
|
| Re: Last DML on a table [message #371892 is a reply to message #371876] |
Mon, 18 December 2000 08:50  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
You can look at the tracing files if you have tracing on.
The best way to monitor an object is to start auditing.....
You can say "audit update, delete, insert on table1 by scott;"
which will produce your desired result....
Before starting audit
See the manuals for the adv and disadv of auditing on your database.
Bala
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
