« mysql: rownum functionality | Home | Spiraling quine in Perl »

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.

Keep on coding