Oracle: using recycling bin

Information about the objects in recycle bin:

select object_name,
original_name, type,
can_undrop , can_purge ,
from recyclebin


show recyclebin


flashback table mytable to before drop;

Clear recycle bin

purge recyclebin;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.