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!

Errors importing TTS using impdp

656218Jul 30 2012 — edited Jul 31 2012

Hello All,

I am seeing following errors when importing TTS using impdp. Please let me know if you know any work around.

Thanks,
Sunny boy

Corp_DEODWPRD$ impdp parfile=impdp_tts.par

Import: Release 11.2.0.3.0 - Production on Mon Jul 30 13:23:50 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_02" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_02": /******** AS SYSDBA parfile=impdp_tts.par
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
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 FROM "SYS"."SYS_IMPORT_TRANSPORTABLE_02" 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 9001

----- PL/SQL Call Stack -----
object line object
handle number name
0x5d9562370 20462 package body SYS.KUPW$WORKER
0x5d9562370 9028 package body SYS.KUPW$WORKER
0x5d9562370 4185 package body SYS.KUPW$WORKER
0x5d9562370 9725 package body SYS.KUPW$WORKER
0x5d9562370 1775 package body SYS.KUPW$WORKER
0x59c4fbb90 2 anonymous block

Job "SYS"."SYS_IMPORT_TRANSPORTABLE_02" stopped due to fatal error at 13:52:57

*************************************************************************************************

PAR file:

USERID='/ as sysdba'
directory=ODW_MIG_DIR
dumpfile=exp_full_ODW_tts_20120719_01.dmp
logfile=imp_FULL_ODW_TTS_20120730.log
exclude=PROCACT_INSTANCE
TRANSPORT_DATAFILES=(
'+DEODW_DATA_GRP/deodwprd/data/ts_appsds_d_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/ts_appsds_i_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_aud_d_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_02.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_03.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d_p2012_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_capone_i01_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_3.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_2.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_1.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_cst_stage_d_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_cst_stage_i_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_dsdw_doc_stg_d01_01.dbf',
.
.
.
'+DEODW_DATA_GRP/deodwprd/data/deodw_x_etl_d01_02.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_x_report_work_d01_01.dbf',
'+DEODW_DATA_GRP/deodwprd/data/deodw_x_sas_d01_01.dbf')