History of activity on oracle 10G DB!

[Inandjo]

Hi,

I have an oracle DB where some tables have been wipped out sometime between yesterday and last thursday.
Is there a utility on oracle where i can just find when this was done, and(ideally) find the bastard who goofed on this one and nail him??

Thank you!

La faim justifie les moyens!

 

[stefanhei]

Hi,

If your DB runs in archivelog mode you may use logminer.
In case DML (delete, update,...) was used you'll find out time and user. As additional bonus you will be able to undo the malicious actions.
In case DDL (truncate, drop,...) was used you should be able to find out at least when it was done.

Stefan

 

[Beilstwh]

If you have it turned on, you can also use flashback to recover. See the following link.

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9012.htm#SQLRF01802

Bill
Oracle DBA/Developer
New York State, USA