开发者

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


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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜