How to clean recyclebin (database tables) on Oracle 10g and later

Oracle 10g has a feature called recycle bin. Whenever you drop a table it removes the table but it also saves it under name BIN$...(string of chars). After a while, a lot of tables in recycle bin become useless and annoying. To purge all these dropped tables from a recycle bin, connect to the database and appropriate schema and issue sqlplus command 'purge recyclebin'.

  • No labels