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;

Topics: Oracle, delete, restore | Submitter: checkthis

Comments

You must be logged in to post a comment.