In Oracle10g, how does one delete a junk table?

In the actual use of Oracle10g, you encounter this situation, that is, some of the previously deleted tables appear many junk tables in the Oracle database, such: for tables that cannot be deleted at all, such as BINjR8PK5HhrrgMK8KmgQ9nw =, delete cannot be used. This generally does not affect normal use, but we must delete it in the following cases.

1, these tables occupy space 2, if the use of Middlegen-Hibernate-r5 friends will find some problems, not you as before using Oracle9 so generate hibernate configuration file, the reason is to delete it here, so there is no problem.

3. In other cases, BINjR8PK5HhrrgMK8KmgQ9nw = is a new 10g table.

After Drop Table, the Table is not deleted, but in the "garbage station. You can see it through SQL> SHOW RECYCLEBIN. If you want to delete it permanently,

Usage:

 
 


  
  
SQL> PURGE TABLE "BINjR8PK5HhrrgMK8KmgQ9nw = ";

 
 

Delete this or SQL> PURGE RECYCLEBIN; Delete All.

The above content is an introduction to how to delete the junk table in Oracle10g. I hope you will have some gains.