web analytics

Oracle: using recycling bin

Information 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;