Latest solution for deleting Oracle10g junk table

If you frequently use Oracle10g, you can find that many junk tables are frequently displayed in some databases in the tables that you deleted previously, these junk tables cause a lot of inconvenience in actual operations. Below are some examples of junk tables.

 
 

  
  
BINjR8PK5HhrrgMK8KmgQ9nw== 
 
 

This type of table cannot be deleted and cannot be deleted using "delete". In this case,

It generally does not affect normal use, but must be deleted in the following situations.

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 smoothly generated hibernate configuration file, the reason is to delete it here there is no problem.

3. Other cases

 
 

  
  
BINjR8PK5HhrrgMK8KmgQ9nw== 
 
 

This type of table is a new feature of Oracle10g.

After Drop Table, the Table is not deleted, but in the "garbage station. You can see below.

 
 

  
  
SQL> SHOW RECYCLEBIN 
 
 

To completely delete a file, you can use:

 
 

  
  
SQL> PURGE TABLE "BINjR8PK5HhrrgMK8KmgQ9nw=="; 
 
 

Delete this or delete all.

 
 

  
  
SQL> PURGE RECYCLEBIN; 
 
 

The above is an introduction to the latest methods for deleting Oracle10g junk tables. I hope you will find some gains.

Article by: http://www.programbbs.com/doc/class10-1.htm