10G recyclebin

[vnktummala]

Hi,

I am happened to work on a user ticket today to restore a dropped table. I am lucky to find that table in recycle bin and flashback the table to before drop.

when i am working on this i have found few more tables in recycle bin which were deleted at the same time but when i check in the schema those tables are there in schema. The count of each table in schema is in millions and the count in recyclebin is 0.

Here is the excerpt of two out of 15 tables in recyclebin.

OPSPOSTED BIN$cziUycnhACrgRAAhKAKXzA==$0 TABLE 2009-09-10:23:34:24
PPDPOSTED BIN$cziUycn/ACrgRAAhKAKXzA==$0 TABLE 2009-09-10:23:34:25

Here is the output from obj$ for these two tables.

select name,ctime from obj$ where name in ('OPSPOSTED','PPDPOSTED');

OPSPOSTED 10-09-09 23:34:24
PPDPOSTED 10-09-09 23:34:25

These tables are actually created in last year December but the creation date is showing yesterday.

I am just wondering why these tables are showing in recyclbin and why the create time has changed. I appreciate any advise on this.

Thanks,

[vnktummala]

okay ... I am trying to find who dropped these tables. I ran the historical ash report from 11:30 - 11:40 but surprisingly it didn't show me any drop table sql.

I find one session from TOAD connected using the schema owner name which exists for 3 minutes. I am not able to find what that session did in that 3 minutes.

Can some one shed some light and guide me how to find the culprit who dropped the tables?

Thanks,