数据库版本 11.2.0.3.0
使用impdp + network_link 功能不落地同步数据表。
已知:
源库 dw.dw_c_d_user_all:P_201407 和 dw.dw_c_d_user_all:P_201408 实际均有数据。
SQL> SELECT COUNT(*) FROM DW.DW_C_D_USER_ALL PARTITION(P_201407) UNION ALL SELECT COUNT(*) FROM DW.DW_C_D_USER_ALL PARTITION(P_201408);
COUNT(*)
----------
271697
307026
使用impdp user/********tables=dw.dw_c_d_user_all:P_201407 network_link=boncbi_145 table_exists_action=TRUNCATE CONTENT=DATA_ONLY
impdpuser/********tables=dw.dw_c_d_user_all:P_201408 network_link=boncbi_145 table_exists_action=TRUNCATE CONTENT=DATA_ONLY
201407 无法同步数据, 但201408可以。
类似的表还有很多,不解
源库 DW.DW_C_D_USER_ALL 已经执行表分析
CALL DBMS_STATS.GATHER_TABLE_STATS('DW','DW_C_D_USER_ALL','P_201407');
CALL DBMS_STATS.GATHER_TABLE_STATS('DW','DW_C_D_USER_ALL','P_201408');
目的库是否已经建表,对执行结果无影响。
请各位老师帮忙解答。 谢谢。
$ impdp user/********tables=dw.dw_c_d_user_all:P_201407network_link=boncbi_145 table_exists_action=TRUNCATECONTENT=DATA_ONLY
Import: Release 11.2.0.3.0 - Production on Tue Sep 16 14:59:51 2014
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
Starting "XXX"."SYS_IMPORT_TABLE_01": user/******** tables=dw.dw_c_d_user_all:P_201407 network_link=boncbi_145 table_exists_action=TRUNCATE CONTENT=DATA_ONLY
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 65 MB
. . imported "DW"."DW_C_D_USER_ALL":"P_201407"
0 rows
Job "XXX"."SYS_IMPORT_TABLE_01" successfully completed at 14:59:55
$ impdpuser/********tables=dw.dw_c_d_user_all:P_201408network_link=boncbi_145 table_exists_action=TRUNCATECONTENT=DATA_ONLY
Import: Release 11.2.0.3.0 - Production on Tue Sep 16 15:00:03 2014
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
Starting "XXX"."SYS_IMPORT_TABLE_01":user/********tables=dw.dw_c_d_user_all:P_201408 network_link=boncbi_145 table_exists_action=TRUNCATE CONTENT=DATA_ONLY
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 82 MB
. . imported "DW"."DW_C_D_USER_ALL":"P_201408" 307026 rows
Job "XXX"."SYS_IMPORT_TABLE_01" successfully completed at 15:00:18
复制代码
|