What are the BIN$... tables in Oracle's ALL_TAB_COLUMNS table?

Question

When I query ALL_TAB_COLUMNS in Oracle, I see tables called

BIN$frKctA83wMPgQEOSh0Az+A==$0
BIN$frKctA8cwMPgQEOSh0Az+A==$0
BIN$frQ1pdU2TgXgQEOSh0APxA==$0
BIN$frQ1pdVGTgXgQEOSh0APxA==$0

There is no corresponding entry in ALL_TABLES. What are those?

Answer 1

Hi Aaron,

Since version 10g, dropped tables (also dropped objects in general) are put in the recycle bin and can be restored easily. The names you see are tables in the recycle bin.

You can bypass the recycle bin by adding the PURGE keyword in your DROP statements.

You will find additional information in the Administrator's Guide Documentation.