IMPDP Raises ORA-39068: Invalid Master Table Data In Row With PROCESS_ORDER=-1 And ORA-1403 (Doc ID 1556555.1)

Last updated on MAY 28, 2013

Applies to:

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

Symptoms

Running 11.2.0.3 IMPDP to import a full database dump results in the following errors :

ERROR
-----------------------
ORA-39068: invalid master table data in row with PROCESS_ORDER=-1
ORA-01403: no data found
----- Current SQL Statement for this session (sql_id=agtj50h1m9xdz) -----
BEGIN :1 := sys.kupc$que_int.attach_queue(:2, :3, :4); END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x68c228b8       338  package body SYS.DBMS_PRVTAQIS
0x68c228b8       814  package body SYS.DBMS_PRVTAQIS
0x68ace5a8      6214  package body SYS.DBMS_AQADM_SYS
0x68d4dd48       230  package body SYS.KUPC$QUE_INT
0x68d4dd48      1387  package body SYS.KUPC$QUE_INT
0xdf32b800         1  anonymous block
0xdfb13548       110  package body SYS.KUPC$QUEUE_INT
0x71e22070      1149  package body SYS.KUPW$WORKER
0x684a9eb8         2  anonymous block

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