My Oracle Support Banner

ORA-39127 / ORA-1403 Reported for Queue Tables During DataPump Export (Doc ID 2300076.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

Data Pump export is failing with

ORA-39127: unexpected error from call to export_string :=SYS.DBMS_AQ_EXP_QUEUE_TABLES.INSTANCE_INFO_EXP('WM$EVENT_QUEUE_TABLE','WMSYS',1,1,'11.02.00.04.00',newblock)
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_SYS_EXP_ACTIONS", line 123
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUE_TABLES", line 20
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 9876

Changes

 Schema Export using EXPDP was reporting ORA-1403 on some of the AQ tables, although it was not affecting the actual EXPDP operation.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.