大家好,我用如下命令想导出分区表的数据:
expdp imp_user/oracle directory=datapump_dir \
logfile=exp_kmdw_par_tab.log dumpfile=exp_kmdw_par_tab.dmp \
tables=biuser.w_dim_status_flow:SYS_P41,biuser.w_dim_status_flow:SYS_P42,biuser.w_dim_status_flow:SYS_P43,biuser.w_dim_status_flow:SYS_P44, \
biuser.w_dim_status_flow:SYS_P61,biuser.w_dim_status_flow:SYS_P21, \
operview.dm_cnkm_forecast_basic:PART1,operview.dm_cnkm_forecast_basic:PART2,operview.dm_cnkm_forecast_basic:PART3,operview.dm_cnkm_forecast_basic:PART4, \
operview.dm_cnkm_forecast_basic:PART5,operview.dm_cnkm_forecast_basic:PART6,operview.dm_cnkm_forecast_basic:PART7,operview.dm_cnkm_forecast_basic:PART8, \
operview.dm_cnkm_forecast_basic:PART9,operview.dm_cnkm_forecast_basic:PART10,operview.dm_cnkm_forecast_basic:PART11,operview.dm_cnkm_forecast_basic:PART12 \
compression=all \
content=data_only \
network_link=kmdw_90_dblink
但是结果却显示;
. . exported "BIUSER"."W_DIM_STATUS_FLOW":"SYS_P21"5.281 KB 0 rows
. . exported "BIUSER"."W_DIM_STATUS_FLOW":"SYS_P61"5.281 KB 0 rows
. . exported "BIUSER"."W_DIM_STATUS_FLOW":"SYS_P43"5.281 KB 0 rows
. . exported "BIUSER"."W_DIM_STATUS_FLOW":"SYS_P44"5.281 KB 0 rows
. . exported "BIUSER"."W_DIM_STATUS_FLOW":"SYS_P42"5.281 KB 0 rows
. . exported "BIUSER"."W_DIM_STATUS_FLOW":"SYS_P41"5.281 KB 0 rows
. . exported "BIUSER"."W_DIM_STATUS_FLOW":"PFLOW2010"5.281 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART3"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART7"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART1"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART10"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART11"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART12"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART2"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART4"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART5"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART6"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART8"5.140 KB 0 rows
. . exported "OPERVIEW"."DM_CNKM_FORECAST_BASIC":"PART9"5.140 KB 0 rows
Master table "IMP_USER"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for IMP_USER.SYS_EXPORT_TABLE_01 is:
/ora_files/datapump/exp_kmdw_par_tab.dmp
Job "IMP_USER"."SYS_EXPORT_TABLE_01" successfully completed at Fri Dec 16 15:03:45 2016 elapsed 0 00:00:05
0 rows!!!无法导出,另外,即使我不指定分区,而是将整个表导出,还是不行:
expdp imp_user/oracle directory=datapump_dir \
logfile=exp_kmdw_par_tab.log dumpfile=exp_kmdw_par_tab.dmp \
tables=biuser.w_dim_status_flow,operview.dm_cnkm_forecast_basic \
compression=all \
content=data_only \
network_link=kmdw_90_dblink
结果跟上面一样,都是显示 0 rows!!!
请问哪位兄台能解决一下这个问题,急啊~~~
|