JDBC Connection + Oracle 10g + recycle bin…

Since Oracle 10g dropped tables goes into a recycle bin: http://orafaq.com/node/968. These tables aren’t visible inside the admin site under the user but if you are using JDBC to access the schema. Thought first of a bug in SQL Explorer when i saw the huge list of tables starting with BIN$… Every time you drop tables more BIN$ you get… If someone needs such a future… I’m more a friend of the “know what i’m doing’ approach. The good thing is that this is a feature which you can disable:

  1. sqlplus sys/<your password> as sysdba
  2. SQL> purge dba_recyclebin;
  3. SQL> alter system set recyclebin = OFF scope=both;