Hello,experts
I use IMPDP command to migrate data to another Oracle DB,this process spend about 20 hours and content that generated logfile 'impdp_sd_res_three_table_20170911.log' as follows,
[oracle@cq-hbk-dn-100 impdp]$ cat impdp_sd_res_three_table_20170911.log
;;;
Import: Release 11.2.0.3.0 - Production on Mon Sep 11 15:49:31 2017
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, OLAP, Data Mining and Real Application Testing options
Master table "RESBAK"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "RESBAK"."SYS_IMPORT_TABLE_01": resbak/********@resbak directory=impdp remap_schema=szd_resource_v2:resbak tables=szd_resource_v2.sd_res_case_map,szd_resource_v2.sd_res_id_case,szd_resource_v2.sd_res_resource parallel=3 dumpfile=expdp_szd_resource_v2_20170911040001_%U.dmp logfile=impdp_sd_res_three_table_20170911.log table_exists_action=truncate
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Table "RESBAK"."SD_RES_CASE_MAP" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate
Table "RESBAK"."SD_RES_ID_CASE" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate
Table "RESBAK"."SD_RES_RESOURCE" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "RESBAK"."SD_RES_CASE_MAP" 3.303 GB 25540961 rows
. . imported "RESBAK"."SD_RES_RESOURCE" 10.31 GB 28549410 rows
. . imported "RESBAK"."SD_RES_ID_CASE" 12.55 GB 15003728 rows
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_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/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "RESBAK"."SYS_IMPORT_TABLE_01" successfully completed at 12:38:33
Now,how to solve this problem? Please give me some suggestions,thanks!
Regards,
Quanwen Zhao