Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Recycle Bin


Introduced in 10g version of oracle.
From 10g, once we drop a table, oracle considers or marks that table as dropped but retains the table in the recycle bin.
As such there is no separate memory area allocated for recycle bin.
Whatever the space occupied by the segment, that space will be considered as the space for recycle bin.
Oracle retains the table in the recycle bin, until there is space for the incoming object in the datafile. If there is no space, oracle drops the segments permanently.

SQL> select * from dba_recyclebin;
- to see the dropped object that are in the recycle bin.
SQL> drop table emp purge;
- to drop a table permanently without sending it into recycle bin.

Related Posts Plugin for WordPress, Blogger...

Flag Counter