How to Find

Datebase: Oracle 8i R8.1.6
OS : HP Unix 11.0

How we can find who has deleted the records from a table and when . Only thing we know at this point is name of the Table.

TKPROF is not turned ON and also Trace is not Turned ON Specifically. Is there any Log file generated by Oracle to see from that.

One way is by using Log Miner.

If any one knows any other way pls do share.

Thanks for the knowledge sharing.

only other way I can think of is auditing if turned on.

As Sureshy says if you don't have auditing switched on then log miner is your only option.

Regards

Logminer is probably the best way. You can use http://www.oracle-base.com/Articles/8i/LogMiner.asp to find out how to use it...

And for the cows that haven't left the barn, you can use triggers to capture DML (the who and when of it, not the actual DML) on key tables.