online also checked the reason, say Oracle a bug (http://bbs.cldera.com/archiver/tid-31175.html), also didn't find the right solution, do not know to have people met, please answer, thank!
Note: the following is my according to get the export the file to write some of the statements, do not know whether there are any errors, please teach
finally attached to the import log file of the data, for your reference, also please feel free to comment!
;;;
Import: Release 11.2.0.1.0 - Production on Wednesday September 13 17:12:24 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
To connect to: Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options
Has succeeded in loading/unloading the main table "SXDS". "SYS_IMPORT_FULL_16
"Start "SXDS". "SYS_IMPORT_FULL_16" : SXDS/* * * * * * * * @ SXDS directory=dumpdir dumpfile=db_dw_dump % U.d mp logfile=SXDS. The log remap_schema=DB_DW: SXDS
Handle object types SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA - 39126: in KUPW $WORKER. UPATE_TD_ROW_IMP [64] of the WORKER accident fatal error
TABLE_DATA: "SXDS". "BD_DIM_TC"
ORA - 31603: object "BD_DIM_TC" belongs to the type of TABLE, is not found in the program "SXDS"
ORA - 06512: in the "SYS. DBMS_SYS_ERROR", line 105
ORA - 06512: in the "SYS. KUPW $WORKER", line 8171
PL/SQL Call Stack -- -- -- -- -- -- -- -- -- --
Object the line object
Handle number name
00000004 aa2b88b8 18990 package body SYS. KUPW $WORKER
00000004 aa2b88b8 8192 package body SYS. KUPW $WORKER
00000004 aa2b88b8 18552 package body SYS. KUPW $WORKER
00000004 aa2b88b8 4105 package body SYS. KUPW $WORKER
00000004 aa2b88b8 8875 package body SYS. KUPW $WORKER
00000004 aa2b88b8 1649 package body SYS. KUPW $WORKER
0000000485 c40dd8 anonymous block
ORA - 39126: in KUPW $WORKER. UPATE_TD_ROW_IMP [64] of the WORKER accident fatal error
TABLE_DATA: "SXDS". "BD_DIM_TC"
ORA - 31603: object "BD_DIM_TC" belongs to the type of TABLE, is not found in the program "SXDS"
ORA - 06512: in the "SYS. DBMS_SYS_ERROR", line 105
ORA - 06512: in the "SYS. KUPW $WORKER", line 8171
PL/SQL Call Stack -- -- -- -- -- -- -- -- -- --
Object the line object
Handle number name
00000004 aa2b88b8 18990 package body SYS. KUPW $WORKER
00000004 aa2b88b8 8192 package body SYS. KUPW $WORKER
00000004 aa2b88b8 18552 package body SYS. KUPW $WORKER
00000004 aa2b88b8 4105 package body SYS. KUPW $WORKER
00000004 aa2b88b8 8875 package body SYS. KUPW $WORKER
00000004 aa2b88b8 1649 package body SYS. KUPW $WORKER
0000000485 c40dd8 anonymous block
Homework "SXDS". "SYS_IMPORT_FULL_16" because of a fatal error in 17:12:32 stop
here is some information for the export data log, for your reference
;;;
Export: Release 11.2.0.4.0 - Production on Fri Sep 1 19:23:02 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to the Oracle Database 11 g Enterprise Edition Release 11.2.0.4.0-64 - bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining,
And Real Application Testing options
Starting "DB_DW". "SYS_EXPORT_SCHEMA_04" : DB_DW/* * * * * * * * directory=DIR_DB logfile=db_dw_dmp. Log dumpfile=U.d mp filesize db_dw_dump %=200 g
Estimate the progress in using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
The Total estimation using BLOCKS method: 892.4 GB
.. exported "DB_DW". "ZH_ZM_SRNSMX_TEMP" 37.29 GB 169462422 rows
.. exported "DB_DW". "ZH_CW_ZCFZB_XQYKJZZ_JS" 16.74 GB 166585890 rows
.. exported "DB_DW". "ZH_SB_CWBB_XQYKJZZ_ZCFZB" 16.76 GB 94387219 rows
.. exported "DB_DW". "ZH_SB_KJGRSDSBGB_MX_TEMP" 16.36 GB 82223769 rows
.. exported "DB_DW". "ZH_DJ_GSNSRSRNSXX2" 14.75 GB 63151613 rows
.. exported "DB_DW". "ZH_SB_CWBB_XQYKJZZ_LRB" 13.01 GB 80729600 rows
.. exported "DB_DW". "ZH_ZM_SSWSZMJLMX_TEMP" 12.08 GB 67915344 rows
.. exported "DB_DW". "ZH_CW_LRB_XQYKJZZ_JS" 11.10 GB 100243968 rows
.. exported "DB_DW". "ZH_DJ_NSRXX_ZH" 10.64 GB 62384034 rows
.. exported "DB_DW". "ZH_SB_CWBB_XQYKJZZ_XJLLB" 9.630 GB 54952370 rows
.. exported "DB_DW". "ZH_CW_ZCFZB_QYKJZD_JS" 9.205 GB 90448896 rows
.. exported "DB_DW". "ZH_DJ_BLXTTBSBRZXX" 8.439 GB 9748451 rows
.. exported "DB_DW". "ZH_SB_KJGRSDSBGB_MX_NEU" 8.585 GB 42021804 rows
.. exported "DB_DW". "JS_SY_NSRFSZRKXX" 7.995 GB 161909999 rows
.. exported "DB_DW". "ZH_SB_ZSXX" 7.828 GB 25378295 rows
.. exported "DB_DW". "ZH_SB_SBXX_OLD" 7.434 GB 46196440 rows
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull