ORA-10862: resolve default queue owner to current user in enqueue/dequeue ORACLE 报错 故障修复 远程处理

文档解释

ORA-10862: resolve default queue owner to current user in enqueue/dequeue

Cause: resolve default queue owner to current user in enqueue/dequeue.

Action: turn on if client wish to resolve the default queue owner to the current user. If not turned on, the default queue owner will be resolved to the login user.

ORA-10862：表示在执行enqueue/dequeue操作时，未解析出默认的队列拥有者。

官方解释

在使用 oracle Advanced Queueing (AQ) 时，ORA-10862 表示未解析出 what the default queue owner should be. 常见的原因是在尝试构建队列之前没有设置对象的拥有者 (owner)。

常见案例

当尝试建立一个AQ队列时，如果未指定队列拥有者时可能出现错误ORA-10862：

sql> BEGIN

DBMS_AQADM.CREATE_QUEUE ( queue_name => ‘MY_NEW_QUEUE’ );

END;

/

BEGIN

*

ERROR at line 1:

ORA-10862: resolve default queue owner to current user in enqueue/dequeue

正常处理方法及步骤

要解决此错误，应该显式地指定一个队列拥有者：

SQL> BEGIN

DBMS_AQADM.CREATE_QUEUE ( queue_name => ‘MY_NEW_QUEUE’, queue_table => ‘MY_Qtable’, owner => ‘MyUser’ );

END;

/

PL/SQL 过程已正常完成。