«  
  »

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;
November 17th, 2009 | Tags: , | Category: Oracle

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>