Oracle的ALL_TAB_COLUMNS表中的BIN $ ...表是什么? [英] What are the BIN$... tables in Oracle's ALL_TAB_COLUMNS table?

问题描述

当我在Oracle中查询ALL_TAB_COLUMNS时，我看到了名为

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

ALL_TABLES中没有相应的条目.那是什么?

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

推荐答案

从10g版开始，已删除的表(通常也是已删除的对象)被放入回收站，并且可以轻松地进行恢复.您看到的名称是回收站中的表格.

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.

您可以通过添加 PURGE 关键字.

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

您将在管理员的目录中找到其他信息指南文档.

这篇关于Oracle的ALL_TAB_COLUMNS表中的BIN $ ...表是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！