In 10g oracle has introduced the concept of recycle bin one can recover tables that were dropped. When a table is dropped, the column “DROPPED” is marked “YES” in the view user_tables/all/dba_tables.

USER_RECYCLEBIN – This view has dropped objects in current user’s schema

Clean current user’s recycle bin
SQL> purge recyclebin;

Recyclebin purged.

DBA_RECYCLEBIN – Has dropped objects in all users

# purge all tables in the recycle bin
SQL> purge dba_recyclebin;

DBA Recyclebin purged.

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.