ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-12083:must user DROP MATERIALIZED VIEW ...

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

原创 Linux操作系统 作者:deszjj 时间:2012-06-07 10:29:36 0 删除 编辑
错误现象:
        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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-04-07

  • 博文量
    42
  • 访问量
    116013