Causes and solutions for strange table names in Oracle databases

The following articles mainly introduce the strange table names in Oracle databases. The main reason is that the Oracle10g recycle bin does not completely delete the relevant tables, instead, we put the table into the recycle bin. At last, such a pile of strange table names appeared ......

The cleanup method is as follows:

 
 


  
  
Purge table origenal_tableName;

  
  
Purge index origenal_indexName;

 
 

To query junk information, use the following SQL statement:

 
 


  
  
SELECT t. object_name, t. type, t. original_name FROM user_recyclebin t;

 
 

The following command is available:

 
 


  
  
PURGE recyclebin;

 
 

It cannot be as complicated as above. Haha!

In addition, the method for deleting a Table that does not enter Recycle is as follows:

 
 


  
  
Drop table tableName purge;

 
 

However, I don't think most people would like to use this.

The above content is an introduction to the Oracle database. I hope you will get some benefits.