[[email protected] ~]$ IMPDP \ '/as SYSDBA \ ' DIRECTORY=EXPDP dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog remap_t Ablespace=wxlun:wxlun_data remap_schema=wxlun:wxlun0402
Import:release 11.2.0.3.0-production on Thu APR 2 10:46:29 2015
Copyright (c) 1982, 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, Real application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real application testing options
Master table "SYS". " Sys_import_full_01 "Successfully loaded/unloaded
Starting "SYS". " Sys_import_full_01 ":"/******** as SYSDBA "DIRECTORY=EXPDP dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog REMAP_ Tablespace=wxlun:wxlun_data remap_schema=wxlun:wxlun0402
Processing Object Type Schema_export/user
Ora-31684:object type USER: "wxlun0402" already exists------User has been created, error ignored
Processing Object Type Schema_export/system_grant
Processing Object Type Schema_export/role_grant
Processing Object Type Schema_export/default_role
Processing Object Type Schema_export/pre_schema/procact_schema
Processing Object Type Schema_export/table/table
Processing Object Type Schema_export/table/index/index
Processing Object Type Schema_export/table/constraint/constraint
Processing Object Type Schema_export/table/index/statistics/index_statistics
Processing Object Type Schema_export/table/comment
Processing Object Type Schema_export/table/statistics/table_statistics
---below to get an error---
Ora-39014:one or more workers has prematurely exited.
Ora-39029:worker 1 with process name "DW00" prematurely terminated
Ora-31671:worker process DW00 had an unhandled exception.
Ora-04030:out of process memory when trying to allocate 16048 bytes (session heap,kuxlpxalloc)
Ora-06512:at "SYS. Kupw$worker ", line 1838
Ora-06512:at Line 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 From "SYS". " Sys_import_full_01 "WHERE process_order between:3 and:4 and duplicate = 0 and Processing_state not in (: 5,: 6,: 7) Orde R by Process_order]
ora-19505:failed to identify file "/u01/oracle/expdp/wxlun0402.dmp"
Ora-27037:unable to obtain file status
linux-x86_64 error:2: No such file or directory
Additional Information:3
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
0x17c15e530 20462 Package Body SYS. Kupw$worker
0x17c15e530 9028 Package Body SYS. Kupw$worker
0x17c15e530 4185 Package Body SYS. Kupw$worker
0x17c15e530 9725 Package Body SYS. Kupw$worker
0x17c15e530 1775 package Body SYS. Kupw$worker
0x172f16550 2 anonymous block
Ora-39014:one or more workers has prematurely exited.
Ora-39029:worker 3 with process name "DW00" prematurely terminated
Ora-31671:worker process DW00 had an unhandled exception.
Ora-04030:out of process memory when trying to allocate 120048 bytes (session heap,kuxlpxalloc)
Ora-06512:at "SYS. Kupw$worker ", line 1838
Ora-06512:at Line 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 From "SYS". " Sys_import_full_01 "WHERE process_order between:3 and:4 and duplicate = 0 and Processing_state not in (: 5,: 6,: 7) Orde R by Process_order]
ora-19505:failed to identify file "/u01/oracle/expdp/wxlun0402.dmp"
Ora-27037:unable to obtain file status
linux-x86_64 error:2: No such file or directory
Additional Information:3
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
0x17c15e530 20462 Package Body SYS. Kupw$worker
0x17c15e530 9028 Package Body SYS. Kupw$worker
0x17c15e530 4185 Package Body SYS. Kupw$worker
0x17c15e530 9725 Package Body SYS. Kupw$worker
0x17c15e530 1775 package Body SYS. Kupw$worker
0x172f16550 2 anonymous block
Ora-39014:one or more workers has prematurely exited.
Ora-39029:worker 5 with process name "DW00" prematurely terminated
Ora-31671:worker process DW00 had an unhandled exception.
Ora-04030:out of process memory when trying to allocate 16048 bytes (session heap,kuxlpxalloc)
Ora-06512:at "SYS. Kupw$worker ", line 1838
Ora-06512:at Line 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 From "SYS". " Sys_import_full_01 "WHERE process_order between:3 and:4 and duplicate = 0 and Processing_state not in (: 5,: 6,: 7) Orde R by Process_order]
ora-19505:failed to identify file "/u01/oracle/expdp/wxlun0402.dmp"
Ora-27037:unable to obtain file status
linux-x86_64 error:2: No such file or directory
Additional Information:3
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
0x17c15e530 20462 Package Body SYS. Kupw$worker
0x17c15e530 9028 Package Body SYS. Kupw$worker
0x17c15e530 4185 Package Body SYS. Kupw$worker
0x17c15e530 9725 Package Body SYS. Kupw$worker
0x17c15e530 1775 package Body SYS. Kupw$worker
0x172f16550 2 anonymous block
Ora-39014:one or more workers has prematurely exited.
Ora-39029:worker 7 with process name "DW00" prematurely terminated
Ora-31671:worker process DW00 had an unhandled exception.
Ora-04030:out of process memory when trying to allocate 120048 bytes (session heap,kuxlpxalloc)
Ora-06512:at "SYS. Kupw$worker ", line 1838
Ora-06512:at Line 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 From "SYS". " Sys_import_full_01 "WHERE process_order between:3 and:4 and duplicate = 0 and Processing_state not in (: 5,: 6,: 7) Orde R by Process_order]
ora-19505:failed to identify file "/u01/oracle/expdp/wxlun0402.dmp"
Ora-27037:unable to obtain file status
linux-x86_64 error:2: No such file or directory
Additional Information:3
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
0x17c15e530 20462 Package Body SYS. Kupw$worker
0x17c15e530 9028 Package Body SYS. Kupw$worker
0x17c15e530 4185 Package Body SYS. Kupw$worker
0x17c15e530 9725 Package Body SYS. Kupw$worker
0x17c15e530 1775 package Body SYS. Kupw$worker
0x172f16550 2 anonymous block
Ora-39014:one or more workers has prematurely exited.
Ora-39029:worker 9 with process name "DW00" prematurely terminated
Ora-31671:worker process DW00 had an unhandled exception.
Ora-04030:out of process memory when trying to allocate 16048 bytes (session heap,kuxlpxalloc)
Ora-06512:at "SYS. Kupw$worker ", line 1838
Ora-06512:at Line 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 From "SYS". " Sys_import_full_01 "WHERE process_order between:3 and:4 and duplicate = 0 and Processing_state not in (: 5,: 6,: 7) Orde R by Process_order]
ora-19505:failed to identify file "/u01/oracle/expdp/wxlun0402.dmp"
Ora-27037:unable to obtain file status
linux-x86_64 error:2: No such file or directory
Additional Information:3
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
0x17c15e530 20462 Package Body SYS. Kupw$worker
0x17c15e530 9028 Package Body SYS. Kupw$worker
0x17c15e530 4185 Package Body SYS. Kupw$worker
0x17c15e530 9725 Package Body SYS. Kupw$worker
0x17c15e530 1775 package Body SYS. Kupw$worker
0x172f16550 2 anonymous block
Ora-39014:one or more workers has prematurely exited.
Ora-39029:worker one with process name "DW00" prematurely terminated
Ora-31671:worker process DW00 had an unhandled exception.
Ora-04030:out of process memory when trying to allocate 120048 bytes (session heap,kuxlpxalloc)
Ora-06512:at "SYS. Kupw$worker ", line 1838
Ora-06512:at Line 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 From "SYS". " Sys_import_full_01 "WHERE process_order between:3 and:4 and duplicate = 0 and Processing_state not in (: 5,: 6,: 7) Orde R by Process_order]
ora-19505:failed to identify file "/u01/oracle/expdp/wxlun0402.dmp"
Ora-27037:unable to obtain file status
linux-x86_64 error:2: No such file or directory
Additional Information:3
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
0x17c15e530 20462 Package Body SYS. Kupw$worker
0x17c15e530 9028 Package Body SYS. Kupw$worker
0x17c15e530 4185 Package Body SYS. Kupw$worker
0x17c15e530 9725 Package Body SYS. Kupw$worker
0x17c15e530 1775 package Body SYS. Kupw$worker
0x172f16550 2 anonymous block
Import> exit
^
[Email protected] ~]$ Logout
due to the error in the Processing object type Schema_export/table/statistics/table_statistics, errors and statistics are related, the online introduction says is a bug, IMPDP when adding exclude=statistics, manually collect statistics after import.
Try the following, import complete:
[[email protected] ~]$ IMPDP \ '/as SYSDBA \ ' DIRECTORY=EXPDP dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog remap_t Ablespace=wxlun:wxlun_data remap_schema=wxlun:wxlun0402 Exclude=statistics
Import:release 11.2.0.3.0-production on Thu APR 2 12:52:04 2015
Copyright (c) 1982, 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, Real application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real application testing options
Master table "SYS". " Sys_import_full_02 "Successfully loaded/unloaded
Starting "SYS". " Sys_import_full_02 ":"/******** as SYSDBA "DIRECTORY=EXPDP dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog REMAP_ Tablespacewxlun:wxlun_data remap_schema=wxlun:wxlun0402 Exclude=statistics
Processing Object Type Schema_export/user
Ora-31684:object type USER: "wxlun0402" already exists
Processing Object Type Schema_export/system_grant
Processing Object Type Schema_export/role_grant
Processing Object Type Schema_export/default_role
Processing Object Type Schema_export/pre_schema/procact_schema
Processing Object Type Schema_export/table/table
Processing Object Type Schema_export/table/index/index
Processing Object Type Schema_export/table/constraint/constraint
Processing Object Type Schema_export/table/comment
The Job "SYS". Sys_import_full_02 "completed with 1 error (s) at 13:26:19
IMPDP encounters ORA-39029, ORA-31671, ORA-06512
