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!

Fatal error using 12c IMPDP on 10g datapump file

KlausMogensenMar 19 2019 — edited Mar 20 2019

I'm getting a fatal error with IMPDP when importing a 10g datapump file into a 12c database
The output is below, and it show's that the import craches when importing views
I saw a post suggesting to exclude statistics, but this hasn't helped

Any suggestions

Output:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [VIEW:"VTRACK"."FMC_SUPPORT_LOG_V"]

SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, orig_base_object_schema, base_object_name, orig_base_object_name, base_process_order, parent_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_path_seqno, object_type, object_type_path, object_int_oid, metadata_io,option_tag, objnum, xml_process_order FROM "SYSTEM"."SYS_IMPORT_SCHEMA_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order

ORA-01403: no data found

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 5202

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

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

object line object

handle number name

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

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

00007FFB8AC5E158 5315 package body SYS.KUPW$WORKER.LOAD_METADATA

00007FFB8AC5E158 13108 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS

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

00007FFB8AC66C50 2 anonymous block

Skipping offset, object already reported

Next bad offset is: 211949

Found an object - object row is: 57

l_object_row is: 58

Exiting search_data_loss with 3 errors

Data loss found in 3 objects

KUPF$FILE.CLOSE_CONTEXT

MD Error and handle is still open, closing: 34500001

In procedure DETERMINE_FATAL_ERROR with ORA-01403: no data found

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

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

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, orig_base_object_schema, base_object_name, orig_base_object_name, base_process_order, parent_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_path_seqno, object_type, object_type_path, object_int_oid, metadata_io,option_tag, objnum, xml_process_order FROM "SYSTEM"."SYS_IMPORT_SCHEMA_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]

ORA-01403: no data found

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

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

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

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

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

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

object line object

handle number name

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

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

00007FFB8AC5E158 5315 package body SYS.KUPW$WORKER.LOAD_METADATA

00007FFB8AC5E158 13108 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS

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

00007FFB8AC66C50 2 anonymous block

Next bad offset is: 200504

Skipping offset, object already reported

Next bad offset is: 211949

Found an object - object row is: 57

l_object_row is: 58

Exiting search_data_loss with 3 errors

Data loss found in 3 objects

KUPF$FILE.CLOSE_CONTEXT

In procedure DETERMINE_FATAL_ERROR with ORA-01403: no data found

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

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

Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at Mon Mar 18 18:34:26 2019 elapsed 0 00:28:29

This post has been answered by KlausMogensen on Mar 20 2019

Jump to Answer

Added on Mar 19 2019

#database-key-features, #export-import-sql-loader-external-tables

7 comments

1,886 views