ORA-24005: Inappropriate utilities used to perform DDL on AQ table
CREATE TABLE OBDQ_ADM.AQ$_OBDQ_FAST_TAB_L
(
MSGID RAW(16),
SUBSCRIBER# NUMBER,
NAME VARCHAR2(30 BYTE),
ADDRESS# NUMBER,
DEQUEUE_TIME TIMESTAMP(6) WITH TIME ZONE,
TRANSACTION_ID VARCHAR2(30 BYTE),
DEQUEUE_USER VARCHAR2(30 BYTE),
FLAGS RAW(1)
)
(
MSGID RAW(16),
SUBSCRIBER# NUMBER,
NAME VARCHAR2(30 BYTE),
ADDRESS# NUMBER,
DEQUEUE_TIME TIMESTAMP(6) WITH TIME ZONE,
TRANSACTION_ID VARCHAR2(30 BYTE),
DEQUEUE_USER VARCHAR2(30 BYTE),
FLAGS RAW(1)
)
SQL> ALTER TABLE OBDQ_ADM.AQ$_OBDQ_FAST_TAB_L MODIFY NAME VARCHAR2(30 CHAR);
*
ERROR at line 1:
ORA-24005: Inappropriate utilities used to perform DDL on AQ table OBDQ_ADM.AQ$_OBDQ_FAST_TAB_L
How do I resolve this error!
Regards!
Hine
0