Oracle: using recycling bin
Monday, February 18th, 2008Information about the objects in recycle bin:
SELECT object_name,
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;