Recycle Bin Demystified

The Recycle Bin is a feature of Oracle that stores tables and indexes when we make a drop table, the recyclebin parameter must be set to ON. Often this does not interest us and we desactivadad this functionality. But that does Recycle Bin feature really, basically what it does is rename the table and the indexes associated with this table, of course, includes management of the objects in the bin and a table that is in the trash can be deleted if needed space.

 

An example of doing it by hand would be like this;

  • i) Find all indexes associated with the table

SELECT index_name FROM DBA_INDEXES WHERE table_name = table_to_recycle;

  • ii) Rename the indixes obtained in step i

ALTER INDEX index_name_n RENAME TO new_name_n;

  • iii) Rename the table

RENAME TABLE table_to_recycle TO table_recycled;

Remember for all purposes as such table is not deleted .

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s