ORA-12083：must user DROP MATERIALIZED VIEW ...

最新推荐文章于 2021-04-23 20:49:52 发布

ciyu2310

最新推荐文章于 2021-04-23 20:49:52 发布

阅读量1.2k

点赞数

文章标签：数据库

错误现象：
9206上遇到一个问题：用drop materialized view 删除物化视图后，与视图同名的表没有自动删除（基表所在的远程 数据库 关闭）。于是发出Drop Table 命令，报错ORA-12083：must user DROP MATERIALIZED VIEW ... 。

CAUSE DETERMINATION
====================
This is because of the Bug 4287115.
This is a known issue in 9i , which is fixed in 10g .

POTENTIAL SOLUTION(S)
======================
To workaround the problem , connected as sys run the following update statement. The following update should update only one row. In case if it updates more than one row, then rollback the transaction, which means that this workaround does not apply to your case.

connect sys/ as sysdba
update tab$ set property = property - 100663296 where obj# in (select obj# from obj$ where name='OT_CR_ITEM_X' and owner# in (select USER_ID from all_users where USERNAME=''));
commit;

alter system flush shared_pool;
alter system flush shared_pool;
alter system flush shared_pool;

connect /
Now try dropping the table & it should go through fine.

FROM：http://haochunpeng.itpub.net/post/385/189303

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15489979/viewspace-732119/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15489979/viewspace-732119/