Database Administration (MOSC)

MOSC Banner

ORA-24005: Inappropriate utilities used to perform DDL on AQ table

edited Feb 18, 2013 6:32AM in Database Administration (MOSC) 3 commentsAnswered
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)
)

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center