数据库移植后高级复制出错

跟高级队列有关系.

-- 出错信息

SQL> insert into t1(c1) values(1);
insert into t1 (c1) values(1)
            *
ERROR 位于第 1 行:
ORA-25207: enqueue failed, queue SYSTEM.DEF$_AQCALL is disabled from enqueueing

-- 错误描述

Text:         enqueue failed, queue %s.%s is disabled from enqueueing 

---------------------------------------------------------------------------

Cause:   The queue has been stopped to prevent any further enqueueing. 

Action:         Enable the queue first by using an administrative operation.

-- 解决方法
conn system/manager
exec DBMS_AQADM.START_QUEUE('DEF$_AQCALL', TRUE, TRUE);
exec DBMS_AQADM.START_QUEUE('DEF$_AQERROR', TRUE, TRUE);

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

转载于:http://blog.itpub.net/6906/viewspace-21657/