Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find who dropped the table

751640Dec 9 2010 — edited Dec 9 2010

Hi Gurus,

Is there a way beside auditing to know who dropped the table,i know we could use logminer for that but the thing is that i don't have supplemental logging turned on while the table got dropped.

I think we need to have supplemental logging enabled to find who did what even for the DDL correct?

Is there any way i can find who dropped the table?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2011

Added on Dec 9 2010

#general-database-discussions

14 comments

10,677 views