Hi,
I am trying to import by using below command.
impdp MS/MS@db12 DIRECTORY=DATA_PUMP_NEW DUMPFILE= 12C_OOTB_dump.dmp REMAP_SCHEMA=MS:MS REMAP_TABLESPACE=MS_DATA:MS_DATA REMAP_TABLESPACE=MS_IDX:MS_IDX LOGFILE=LOGFILE_18052016.log;
But I am getting below error message. Kindly help.
====================================================================================================
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/EVENT/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [TABLE_STATISTICS]
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, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid, metadata_io, option_tag FROM "MS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order
ORA-39183: internal error -19 ocurred during decompression phase 2
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 11265
----- PL/SQL Call Stack -----
object line object
handle number name
0xb545d2f0 27116 package body SYS.KUPW$WORKER
0xb545d2f0 11286 package body SYS.KUPW$WORKER
0xb545d2f0 4745 package body SYS.KUPW$WORKER
0xb545d2f0 12063 package body SYS.KUPW$WORKER
0xb545d2f0 2081 package body SYS.KUPW$WORKER
0xb55d5a98 2 anonymous block
In procedure BUILD_OBJECT_STRINGS
In function CONNECT_USER with connect type NONE current connect type NONE current user MS new user MS
DBMS_LOB.TRIM
DBMS_LOB.TRIM
DBMS_LOB.TRIM
DBMS_LOB.TRIM
KUPF$FILE.READ_LOB
KUPF$FILE.CLOSE_CONTEXT
KUPF$FILE.CLOSE_CONTEXT
In procedure DETERMINE_FATAL_ERROR with ORA-39183: internal error -19 ocurred during decompression phase 2
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, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid, metadata_io, option_tag FROM "MS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
ORA-39183: internal error -19 ocurred during decompression phase 2
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
----- PL/SQL Call Stack -----
object line object
handle number name
0xb545d2f0 27116 package body SYS.KUPW$WORKER
0xb545d2f0 11286 package body SYS.KUPW$WORKER
0xb545d2f0 4745 package body SYS.KUPW$WORKER
0xb545d2f0 12063 package body SYS.KUPW$WORKER
0xb545d2f0 2081 package body SYS.KUPW$WORKER
0xb55d5a98 2 anonymous block
BULK COLLECT
57 rows fetched between 86462 and 101158
In procedure COMPLETE_IMP_OBJECT
In procedure UPDATE_TYPE_COMPLETION_ROW
Old Seqno: 0 New Path: SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS PO Num: -6 New Seqno: 250
New object type is TABLE_STATISTICS
KUPF$FILE.READ_LOB
KUPF$FILE.CLOSE_CONTEXT
KUPF$FILE.CLOSE_CONTEXT
In procedure DETERMINE_FATAL_ERROR with ORA-39183: internal error -19 ocurred during decompression phase 2
Job "MS"."SYS_IMPORT_FULL_01" stopped due to fatal error at Wed May 18 03:23:14 2016 elapsed 0 00:52:07