When using oracle10g frequently, we can find that previously deleted tables have a lot of junk tables in the database, as shown in the following example:
BINjR8PK5HhrrgMK8KmgQ9nw==
This type of table usually cannot be deleted and cannot be deleted using "delete". When this happens,
Generally it will not affect normal use, but it must be deleted when encountering the following situations.
◆1.These tables occupy space
◆2. Friends who use Middlegen-Hibernate-r5 will find some problems [Problem description: ORA-01424: Missing or illegal characters after the escape character will appear when running ant build.xml], unlike when you used oracle9 before The hibernate configuration file is generated smoothly, and there is no problem if you delete it here.
◆3.Other situations
BINjR8PK5HhrrgMK8KmgQ9nw==
This type of table is a new feature of 10g.
After Drop Table, the table is not actually deleted, but is placed in the "trash bin". This can be seen below.
SQL> SHOW RECYCLEBIN
If you want to remove it completely, you can use:
SQL> PURGE TABLE "BINjR8PK5HhrrgMK8KmgQ9nw==";
Delete this one or delete all.
SQL> PURGE RECYCLEBIN;