Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Monday, December 15, 2008

BIN$ objects

Object names starting with BIN$ are related to recycle bin. Whenever an object (table, index etc)is dropped, an entry is created in recycle bin with name starting with BIN$, if that is enabled forthe database. They show up in

select * from recyclebin;
show recyclebin

If you do not want dropped tables to go to recyclebin and be deleted permanently you should use


To purge recyclebin you should login as that user and use the command:

purge recyclebin;

To purge the recyclebin of all users login as SYS or SYSTEM and issue the command:

purge dba_recyclebin;

No comments: