blocks|key|1453653|text|您正在使用最新版本的Oracle，并且您的表已放置在RECYCLEBIN中。要在第一个实例中完全摆脱它，您可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1453654|drop+table+<table_name>+purge;|code-block|syntax|javascript|1453655|引用DROP+TABLE上的the+documentation：|1453656|如果要在单个步骤中删除表并释放与其关联的空间，请指定|1453657|。如果指定清除，则数据库不会将表及其从属对象放入回收站。|blockquote|1453658|1453659|..。|1453660|使用此子句相当于首先删除表，然后将其从回收站中清除。此子句允许您在该过程中节省一个步骤。如果您想要防止敏感材料出现在回收站中，它还可以提供增强的安全性。|1453661|1453662|不过RECYCLEBIN可以派上用场。这是一个额外的备份，当您只是意外地丢失了错误的表。如果在删除表时指定PURGE，则永远无法从RECYCLEBIN中检索该表。但是，请注意，如果在不清除的情况下删除，对象所使用的空间将不会被释放。|1453663|要从RECYCLEBIN中删除该表，您可以使用：|1453664|purge+table+"BIN$%2BNP%2BVhP7RF2hLc1AoJf%2Bgg==$0";|1453665|请注意，由于对象名称是大小写的，因此需要使用双引号。|1453666|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables011.htm#ADMIN11679|1|http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_9003.htm#SQLRF01806^0|Q|A|0|0|0|E|H|1|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1D|8|@]|9|@$A|1E|B|1F|1|1G]]|C|$]]|$1|D|3|E|5|F|7|1H|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|1I|8|@]|9|@$A|1J|B|1K|1|1L]]|C|$]]|$1|K|3|L|5|6|7|1M|8|@]|9|@]|C|$]]|$1|M|3|N|5|O|7|1N|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1O|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|1P|8|@]|9|@]|C|$]]|$1|S|3|T|5|6|7|1Q|8|@]|9|@]|C|$]]|$1|U|3|-4|5|6|7|1R|8|@]|9|@]|C|$]]|$1|V|3|W|5|6|7|1S|8|@]|9|@]|C|$]]|$1|X|3|Y|5|6|7|1T|8|@]|9|@]|C|$]]|$1|Z|3|10|5|F|7|1U|8|@]|9|@]|C|$G|H]]|$1|11|3|12|5|6|7|1V|8|@]|9|@]|C|$]]|$1|13|3|-4|5|6|7|1W|8|@]|9|@]|C|$]]]|14|$15|$5|16|17|18|C|$19|1A]]|1B|$5|16|17|18|C|$19|1C]]]]

You're using a recent version of Oracle and your table has been placed in the <a href="http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables011.htm#ADMIN11679" rel="nofollow">RECYCLEBIN</a>. To get rid of it completely in the first instance you can use

<pre><code>drop table &lt;table_name&gt; purge;
</code></pre>

To quote from <a href="http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_9003.htm#SQLRF01806" rel="nofollow">the documentation</a> on DROP TABLE:

<blockquote>
 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.
</blockquote>

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.

To remove the table from the RECYCLEBIN you would use:

<pre><code>purge table "BIN$+NP+VhP7RF2hLc1AoJf+gg==$0";
</code></pre>

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

blocks|key|1442630|text|这通常发生在SSMS中。这背后的原因是，您必须在另一个窗口中打开已删除的表(Design)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1442631|这就是我的情况，cache/bin仍然保留引用，直到上一个设计窗口关闭。|1442632|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This usually happens in SSMS. The reason behind this is, you must have open that dropped table(Design) in another window.
This was my case, cache/bin still preserve the reference until previous design window is closed.

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

<pre><code>DROP TABLE &lt;TABLE NAME&gt; ;
</code></pre>

But when I query

<pre><code>SQL&gt;SELECT * FROM TAB;
</code></pre>

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

How do I drop this type of table?

A table still exists when dropped

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

当我使用这个命令时，它起作用了，这意味着我的表被删除了DROP TABLE <TABLE NAME> ;但是当我查询时SQL>SELECT * FROM TAB;我删除的表没有显示。但其他一些表，如BIN$+NP+VhP7RF2hLc1AoJf+gg==$0，是这样的。如何删除此类型的表？

问删除表后，表仍然存在
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问删除表后，表仍然存在EN