Oracle Recycle bin Utility

Oracle has introduced “Recycle Bin” Feature Oracle 10g to store all the dropped objects.
If any table in Oracle 10g is dropped then any associated objects to this table such as indexes,
constraints and other dependant objects are simply renamed with a prefix of BIN$$.

Testing


Go to SQL*PLUS


1) connect to database



2)  Issue the command select * from tab;





you have tables called emp and dept

3) now delete dept table

4) Issue the command select * from tab;





5) Issue the command as shown in figure to check tables in recyclebin





6) Now recover table dept from recyclebin

7) Now check your table successfully recovered

This is use of recycle bin.

If you really don’t want that table. Before flashback. Just  issue following command.
your tables will deleted permanently

SQL > PURGE RECYCLEBIN

Advertisements
Leave a comment

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

%d bloggers like this: