select count(*) from t_rpt_innerprofitlist
truncate table t_rpt_innerprofitlist
1、建立目录
create or replace directory dir_dp1 as '/dump1';
2、查看创建目录表
select * from dba_directories;
导出expdp
expdp finmanager/dpfintest@192.168.20.108/finance directory=DATA_PUMP_DIR dumpfile=dir_dp0801.dmp tables=t_rpt_innerprofitlist query='"where cfperiod="201305""'
1) skip:默认操作
2) replace:先drop表,然后创建表,最后插入数据
3) append:在原来数据的基础上增加数据
4) truncate:先truncate,然后再插入数据
导入impdp
impdp finmanager/finmanager@192.168.17.209:1521/finance directory=DATA_PUMP_DIR dumpfile=dmp001.dmp tables=t_adv_claims SKIP_UNUSABLE_INDEXES=Y TABLE_EXISTS_ACTION=TRUNCATE