Hi,
One of my developers complained to me that one of the tables in her schema was missing. My question is that is there any way to find out who dropped the table and when? Any help would be appreciated.
Printable View
Hi,
One of my developers complained to me that one of the tables in her schema was missing. My question is that is there any way to find out who dropped the table and when? Any help would be appreciated.
Noway, unless audit enabled on users activity at session level.
see what rsuri suggested works if you are using 8i. Follow this link on How to use Logminer.
http://www.oracle.com/oramag/oracle/99-Sep/59dba2.html
[Edited by sreddy on 01-17-2001 at 06:58 PM]
You may try running Log Miner on the current Redo Logs (or archived logs if it has been archived); I am not sure though if DDLs are recorded there.
- Rajeev