Oracle 请帮忙，不能掉一个腐败的表

大家好，

我们的开发数据库中有一个名为 “to_be_deplot” 的损坏对象。以前它有一个不同的名称，但是有人重命名了它，因为它不能被删除，只能重命名。我们无法找到任何方法将其丢弃。显然，Oracle数据库不确定它是普通表还是实体化视图。这是我尝试的:

DROP TABLE to_be_dropped
Error at line 1
ORA-32417: must use DROP MATERIALIZED VIEW LOG to drop "SCHEMA"."TO_BE_DROPPED"

和

DROP MATERIALIZED VIEW LOG ON to_be_dropped
Error at line 1
ORA-12002: there is no materialized view log on table "SCHEMA"."TO_BE_DROPPED"

和

DROP MATERIALIZED VIEW to_be_dropped
Error at line 1
ORA-12003: materialized view or zonemap "SCHEMA"."TO_BE_DROPPED" does not exist

Okay. After these attempts I tried creating an m-view log on the table. It works. But after dropping this m-view log, the table still remains. So I've created the m-view log again 和 also tried converting this table into a fully-fledged m-view by means of CREATE MATERIALIZED VIEW to_be_dropped ON PREBUILT TABLE... It works. After these steps, TOAD displays the object as a materialized view (originally the object was listed as an ordinary table). But when I drop the m-view, the table still remains!!

有人有想法吗？非常感谢!甚至我们的dba也无法帮助我们摆脱这个物体。

我不确定这里发生了什么。与支持人员联系以查看他们是否可以帮助删除它。

或者，这里是你可以尝试的东西:

-导出不包括此对象的架构
-删除架构
-重新导入架构

或其他一些选项，您可以在其中重建数据库/架构，不包括此表/MV。