Information about the objects in recycle bin:
SELECT object_name,
original_name, TYPE,
can_undrop , can_purge ,
droptime
FROM recyclebin
original_name, TYPE,
can_undrop , can_purge ,
droptime
FROM recyclebin
or
show recyclebin
Restore
flashback TABLE mytable TO before DROP;
Clear recycle bin
purge recyclebin;
Leave a Reply