开发者

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

开发者 https://www.devze.com 2022-12-23 10:58 出处:网络
When I query ALL_TAB_COLUMNS in Oracle, I see tables called BIN$frKctA83wMPgQEOSh0Az+A==$0 BIN$frKctA8cwMPgQEOSh0Az+A==$0

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开发者_开发技巧?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消