删除后表仍然存在 [英] A table still exists when dropped

问题描述

当我使用此命令时，它起作用了，这意味着我的表被删除了

When I used this command it worked, which means my table was dropped

DROP TABLE <TABLE NAME> ;

但是当我查询

SQL>SELECT * FROM TAB;

我的删除表未显示.但是还有其他一些表，例如BIN$+NP+VhP7RF2hLc1AoJf+gg==$0.

My dropped tables are not showing. But some other tables like BIN$+NP+VhP7RF2hLc1AoJf+gg==$0 are.

如何删除这种类型的表?

How do I drop this type of table?

推荐答案

您正在使用Oracle的最新版本，并且您的表已放置在

You're using a recent version of Oracle and your table has been placed in the RECYCLEBIN. To get rid of it completely in the first instance you can use

drop table <table_name> purge;

要引用文档删除表:

如果要删除表并释放空格，请指定清除" 只需一个步骤即可将其关联.如果指定PURGE，则 数据库不会将表及其相关对象放入 回收站.
...
使用此子句等效于首先删除 表格，然后将其从回收站中清除.本条款让 您可以在此过程中节省一个步骤.它还提供增强的安全性 如果您想防止敏感材料出现在 回收站.

Specify PURGE if you want to drop the table and release the space associated with it in a single step. If you specify PURGE, then the database does not place the table and its dependent objects into the recycle bin.
...
Using this clause is equivalent to first dropping the table and then purging it from the recycle bin. This clause lets you save one step in the process. It also provides enhanced security if you want to prevent sensitive material from appearing in the recycle bin.

尽管可以将RECYCLEBIN派上用场……当您意外丢错表时，它可以提供额外的支持.如果在删除表时指定PURGE，则将永远无法从RECYCLEBIN中检索该表.但是请注意，如果在没有 的情况下DROP清除对象使用的空间，将不会释放该空间.

The RECYCLEBIN can come in handy though... it's a additional back-up for when you've just accidentally dropped the wrong table. If you specify PURGE when dropping a table you'll never be able to retrieve the table from the RECYCLEBIN. Note, however, that if you DROP without purging the space used by the object will not be freed.

要从RECYCLEBIN中删除表，您将使用:

To remove the table from the RECYCLEBIN you would use:

purge table "BIN$+NP+VhP7RF2hLc1AoJf+gg==$0";

请注意，由于对象名称是大小写的，因此需要双引号.

Note that as the object name is cased you need the double quotes.

这篇关于删除后表仍然存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！