資料庫移植後高階複製出錯

husthxd發表於2004-12-02

跟高階佇列有關係.


-- 出錯資訊

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部落格 ” ,連結:http://blog.itpub.net/6906/viewspace-21657/,如需轉載,請註明出處,否則將追究法律責任。

相關文章