Aaron Digulla
Reputation: 328566
What are the BIN$... tables in Oracle's ALL_TAB_COLUMNS table?
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?
Upvotes: 27
Views: 32024
Answers (1)
Vincent Malgrat
Reputation: 67722
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.
Upvotes: 39
Related Questions
- difference between "tab" table and all_tables in oracle
- What is the owner of all_tab_statistics in Oracle?
- oracle - what is table name with prefix is BIN$
- Difference between SYS.ALL_TAB_COLUMNS and SYS.ALL_TAB_COLS in Oracle 12c
- Oracle Apex: APEX version of ALL_TAB_COLUMNS
- PL/SQL : ALL_TAB_COLUMNS.table_name%TYPE value
- identify difference from NUMBER(5) and NUMBER(8,2) USER_TAB_COLUMNS
- Oracle, What is the Meaning of Table SYS.SYN$?
- what is all_tab_columns in oracle?
- How can you tell which columns are unused in ALL_TAB_COLS?