ORA-24004 Reported while Executing Datapump or Executing DBMS_AQADM.CREATE_QUEUE_TABLE (Doc ID 2259599.1)

Last updated on AUGUST 09, 2017

Applies to:

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

Symptoms

Oracle Server 12.1.0.2

Executing Datapump Export fails as seen below:

 

$ expdp system/******* schemas=SCOTT ESTIMATE_ONLY=y

Export: Release 12.1.0.2.0 - Production on Tue Nov 24 11:51:57 2015

Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 810
ORA-39244: Event to disable dropping null bit image header during relational select
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 1898
ORA-24004: invalid column name enq_time in SORT_LIST, should be ENQ_TIME or PRIORITY

 

Calling DBMS_AQADM.CREATE_QUEUE_TABLE , also fails with same error:

 

SQL> EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE ( queue_table => 'localaquser.local_queue_table', multiple_consumers => TRUE, queue_payload_type => 'localaquser.message_type', compatible => '8.1.3')

/
BEGIN DBMS_AQADM.CREATE_QUEUE_TABLE ( queue_table => 'localaquser.local_queue_table', multiple_consumers => TRUE, queue_payload_type => 'localaquser.message_type', compatible => '8.1.3'); END;

*
ERROR at line 1:
ORA-24004: invalid column name enq_time in SORT_LIST, should be ENQ_TIME or PRIORITY
ORA-06512: at "SYS.DBMS_AQADM", line 115
ORA-06512: at line 1

 

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