OraFAQ Forum: Server Administration » Finding dropped tables

Home » RDBMS Server » Server Administration » Finding dropped tables

Wed, 10 May 2006 00:52

gajini
Messages: 262
Registered: January 2006

Senior Member

Is there any view or method to find,what are all the tables dropped from the database?

Wed, 10 May 2006 01:18

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Starting from Oracle 10g you can use dba_recyclebin.

Wed, 10 May 2006 01:21

gajini
Messages: 262
Registered: January 2006

Senior Member

In 9i,is there any method?

Wed, 10 May 2006 01:47

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Using Logminer

Wed, 10 May 2006 01:50

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Yes but you have to audit the user. Look into database auditing.

one such example --

AUDIT DROP TABLE ON owner.table_name
BY {SESSION/ACCESS}
WHENEVER {NOT} SUCCESSFUL;

Wed, 10 May 2006 01:55

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Whether auditing on tables will result into performance degradation?

Previous Topic:	Data restore question
Next Topic:	Windows command

Goto Forum:

]

Current Time: Fri Sep 20 10:44:49 CDT 2024