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 the user who dropped the tables

user351483Jan 18 2012 — edited Jan 18 2012

Hi All,

Some one has dropped 5 tables in the production database that has caused a SEV1 but thankfully we are having those tables in recyclebin and we are restored those with out data loss.

But I want to know who has dropped those tables and want to know who has connected to database at that time. Can you please guide me in this how to find out....

Database version: 11.2.0.2 version

Thanks

Kk

Edited by: 908098 on Jan 18, 2012 4:23 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2012

Added on Jan 18 2012

#database, #general-database-discussions

6 comments

2,798 views