DataPump export is performed using COMPRESSION option. When attempting the import into target database the following errors occur:
Master table "ATLAS_TEMP"."SYS_IMPORT_TABLE_18" successfully loaded/unloadedStarting "ATLAS_TEMP"."SYS_IMPORT_TABLE_18": atlas_temp/******** dumpfile=pmbuvsnl_ind_atlas_09Apr2014.dmp logfile=pmbuvsnl_ind_atlas_09Apr2014_imp.log content=data_only version=11.1.0 tables=PMBUVSNL_IND_AGRI_NG.mbl_six,PMBUVSNL_IND_AGRI_NG.dn_six directory=atlas_apr14 remap_schema=PMBUVSNL_IND_AGRI_NG:atlas_temp remap_tablespace=PMBUVSNL_IND_AGRI:ATLAS_TS remap_tablespace=PMBUVSNL_IND_AGRI_IDX:ATLAS_TS table_exists_action=append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "ATLAS_TEMP"."SYS_IMPORT_TABLE_18" stopped due to fatal error at 15:23:01
- The alert log file confirms: ORA-07445 occured:
Errors in file /u01/app/oracle/admin/TC/bdump/tc_dw01_4583456.trc:
ORA-07445: exception encountered: core dump [kdblcbo+02c0] [SIGSEGV] ..
- It turned out, that the affected table was compressed:
SQL> select compression from dba_tables where owner='ATLAS_TEMP' and table_name='MBL_SIX';
COMPRESS
--------
ENABLED
Cause:-
Importing a compressed table with Impdp using direct path method generates ORA-7445 [kdblcbo]. Direct path is the default method that Data Pump uses for loading and unloading data.
Solution:-
Issue will be fixed in RDBMS Release 11.2.
- Alter the table to use NOCOMRESS option
alter table atlas_temp.mbl_six nocompress;ACCESS_METHOD=EXTERNAL_TABLE
- Import the table again it will successfully imported.
Starting "ATLAS_TEMP"."SYS_IMPORT_TABLE_19": atlas_temp/******** dumpfile=pmbuvsnl_ind_atlas_09Apr2014.dmp logfile=pmbuvsnl_ind_atlas_09Apr2014_imp.log content=data_only version=11.1.0 tables=PMBUVSNL_IND_AGRI_NG.mbl_six,PMBUVSNL_IND_AGRI_NG.dn_six directory=atlas_apr14 remap_schema=PMBUVSNL_IND_AGRI_NG:atlas_temp remap_tablespace=PMBUVSNL_IND_AGRI:ATLAS_TS remap_tablespace=PMBUVSNL_IND_AGRI_IDX:ATLAS_TS table_exists_action=append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "ATLAS_TEMP"."MBL_SIX":"P_09APR2014" 470.1 MB 953364 rows
. . imported "ATLAS_TEMP"."DN_SIX":"P_09APR2014" 300.0 MB 908503 rows
Job "ATLAS_TEMP"."SYS_IMPORT_TABLE_19" successfully completed at 15:39:28
Slots & Casino - Dr.CMD
ReplyDeleteSlots & Casino's slot games collection includes the latest slot 당진 출장샵 machines and 경주 출장안마 the latest video slots. The casino's games library includes the Products · Contact 사천 출장샵 · Lists & Blogs 문경 출장마사지 · About 천안 출장마사지