Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Expdp errors with ORA-39126 and ORA-01427 on 12c

DBGuy2000Apr 25 2019 — edited Apr 29 2019

Using

expdp TESTDB/TESTDB DIRECTORY=datapump DUMPFILE=datapump:TESTDB.DMP LOGFILE=datapump:TESTDB.log compression=all

Getting a strange error with EXPDP. Basically failing at this point below any ideas?

Processing object type SCHEMA_EXPORT/JOB

Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPDATE_PROCESS_ORDERS [TABLE_DATA:"TESTDB"."SYS_EXPORT_

SCHEMA_03"]

UPDATE "TESTDB"."SYS_EXPORT_SCHEMA_03" u SET u.base_process_order = (SELECT s.process_order FROM "TESTDB"."SYS_EXPORT_SCHEMA_03" s WHERE s.object_schema = u.base_object_schema AND s.object_name = u.base_object_name AND s.

object_type = 'CONSTRAINT' AND s.processing_state != :1) WHERE u.process_order > 0 AND u.duplicate = 0 AND u.object_type

= :2 AND BITAND(u.flags, :3) != 0

ORA-01427: single-row subquery returns more than one row

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.KUPW$WORKER", line 12098

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.KUPW$WORKER", line 29650

----- PL/SQL Call Stack -----

object line object

handle number name

00007FFC9FC2E1F0 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION

00007FFC9FC2E1F0 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR

00007FFC9FC2E1F0 29818 package body SYS.KUPW$WORKER.UPDATE_PROCESS_ORDERS

00007FFC9FC2E1F0 15241 package body SYS.KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT

00007FFC9FC2E1F0 4128 package body SYS.KUPW$WORKER.UNLOAD_DATA

00007FFC9FC2E1F0 13094 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS

00007FFC9FC2E1F0 2311 package body SYS.KUPW$WORKER.MAIN

00007FFC9AAAB848 2 anonymous block

Updating sequence number 286 with creation level 0

Updated 2 rows

Updating sequence number 301 with creation level 0

Updated 8 rows

1 Non 0 duplicate rows updated

5722 rows updated with process order starting at 1

0 data links rows updated

38 type completion rows updated

3628 rows updated with base process order

In procedure DETERMINE_FATAL_ERROR with ORA-01427: single-row subquery returns more than one row