3

In my scenario, I have a database with no flashback on, Only Archivelogs are active. No Auditing applied on database. 3 days ago some one drop all triggers, views, sequence from a specific user. Now is there any way to find out who did this? Can I go 3 days back without flashback on?

M. AZ
  • 167
  • 3
  • 4
  • 11

1 Answers1

1

Please try it:

Select * from user_audit_object

And for restore dropped table , you should know , that drop did without purge command. If he/she used purge you can just restore your object just with dump or flashback and if he/she didn't use purge you can use this select * from dba_recyclebin where orginal_name=<object_name>, if the select has result you can restore that and otherwise just falshback or restore backup

Vahid
  • 199
  • 4