Error 8103 in Queue Table SYSMAN.MGMT_TASK_QTABLE (Doc ID 1984585.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

All objects associated with Queue Table SYSMAN.MGMT_TASK_QTABLE are Valid. Still getting below error.

ORA-08103: object no longer exists Error 8103 in Queue Table SYSMAN.MGMT_TASK_QTABLE.

select owner,object_name,object_type,status from dba_objects where object_name like '%MGMT_TASK_Q%'  order by 3,2
SQL> /

OWNER   OBJECT_NAME                    OBJECT_TYPE  STATUS
------- ------------------------------ ------------ ------
SYSMAN  AQ$_MGMT_TASK_QTABLE_I         INDEX        VALID
SYSMAN  AQ$_MGMT_TASK_QTABLE_T         INDEX        VALID
SYSMAN  MGMT_TASK_QTABLE_IDX01         INDEX        VALID
SYSMAN  MGMT_TASK_QTABLE_IDX02         INDEX        VALID
SYSMAN  AQ$_MGMT_TASK_QTABLE_E         QUEUE        VALID
SYSMAN  MGMT_TASK_Q                    QUEUE        VALID
SYSMAN  MGMT_TASK_QTABLE               TABLE        VALID
SYSMAN  AQ$MGMT_TASK_QTABLE            VIEW         VALID
SYSMAN  AQ$_MGMT_TASK_QTABLE_F         VIEW         VALID

9 rows selected.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms