Home » SQL & PL/SQL » SQL & PL/SQL » when do apply last dml ?
when do apply last dml ? [message #271840] Wed, 03 October 2007 02:24 Go to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
I have a database that version is Oracle9i Enterprise Edition Release 9.2.0.7.0

i want to find when do I apply last changes data on my production table?

There is no table trigger or something like that.

Regards
Gokhan
Re: when do apply last dml ? [message #271844 is a reply to message #271840] Wed, 03 October 2007 02:48 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't know it unless you enabled auditing.
The other way is to mine your log (see Log Miner).

Regards
Michel
Previous Topic: using array in pl/sql doesnt work - not urgent at all so PLEASE, PLEASE take your time.
Next Topic: Query data rows
Goto Forum:
  


Current Time: Sun Dec 11 04:11:29 CST 2016

Total time taken to generate the page: 0.05216 seconds