首页 > Linux操作系统 > Linux操作系统 > 数据库移植后高级复制出错
跟高级队列有关系.
-- 出错信息
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
-- 错误描述
Error: ORA-25207 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博客 ” ,链接:https://blog.itpub.net/6906/viewspace-21657/ ,如需转载,请注明出处,否则将追究法律责任。