Shulou(Shulou.com)06/01 Report--

First, I believe that many friends have had this kind of experience, when the implementation

Drop table *

And then execute

Select * from tab

There will be a lot of tables that start with BIN$. This is because the Recycle Bin is not cleared after the table is deleted. For example, after Windows deletes files, it is actually in the Recycle Bin and is not really deleted.

Second, query the Recycle Bin method

Select t.object_name,t.type, t.original_name FROM user_recyclebin t

3. Delete the recycling bin

1. Empty the Recycle Bin

Purge recyclebin

2. Delete one by one

Purge table origenal_tableName purge index origenal_indexName

4. at present, you can also set not to enter the Recycle Bin after deleting the table.

Drop table tableName purge

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.