expdp导数脚本

2019独角兽企业重金招聘Python工程师标准>>> hot3.png

2.导入
userid='/ as sysdba'
directory=imp_ml
dumpfile=expd%U.dmp
logfile=impdp.log
parallel=4
JOB_NAME=impdp_job
tables=
EPCISUDWR.PERSONAL_VEHICLE_INFO_ODD
EPCISUDWR.PERSONAL_AUTO_MODEL_NEW_ODD
EPCISUDWR.PERSONAL_AUTO_MODEL_RENEW_ODD
EPCISUDWR.PERSONAL_POLICY_INFO_ODD
table_exists_action=append

3.收集统计信息 —–一个表一条
BEGIN DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'EPCISUDWR',TABNAME => 'PERSONAL_VEHICLE_INFO_ODD', ESTIMATE_PERCENT => 5,METHOD_OPT => 'FOR ALL COLUMNS SIZE REPEAT',DEGREE => 4,GRANULARITY => 'ALL',CASCADE => TRUE,NO_INVALIDATE => FALSE);END;
/
BEGIN DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'EPCISUDWR',TABNAME => 'PERSONAL_AUTO_MODEL_NEW_ODD', ESTIMATE_PERCENT => 5,METHOD_OPT => 'FOR ALL COLUMNS SIZE REPEAT',DEGREE => 4,GRANULARITY => 'ALL',CASCADE => TRUE,NO_INVALIDATE => FALSE);END;
/
BEGIN DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'EPCISUDWR',TABNAME => 'PERSONAL_AUTO_MODEL_RENEW_ODD', ESTIMATE_PERCENT => 5,METHOD_OPT => 'FOR ALL COLUMNS SIZE REPEAT',DEGREE => 4,GRANULARITY => 'ALL',CASCADE => TRUE,NO_INVALIDATE => FALSE);END;
/

转载于:https://my.oschina.net/u/3611008/blog/2885421

Published by

风君子

独自遨游何稽首 揭天掀地慰生平