expdp导数脚本
jan1990 2018-10-30 08:31:11 浏览80 评论0- Oracle
- 脚本
- expdp
摘要： 2.导入userid='/ as sysdba'directory=imp_mldumpfile=expd%U.dmplogfile=impdp.logparallel=4JOB_NAME=impdp_jobtables=EPCISUDWR.
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;
/
BEGIN DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'EPCISUDWR',TABNAME => 'PERSONAL_POLICY_INFO_ODD', ESTIMATE_PERCENT =>
5,METHOD_OPT => 'FOR ALL COLUMNS SIZE REPEAT',DEGREE => 4,GRANULARITY => 'ALL',CASCADE => TRUE,NO_INVALIDATE => FALSE);END;
/
select table_name,LAST_ANALYZED from dba_tables where table_name in ('PERSONAL_VEHICLE_INFO_ODD','PERSONAL_AUTO_MODEL_NEW_ODD','PERSONAL_AUTO_MODEL_RENEW_ODD','PERSONAL_POLICY_INFO_ODD'); 【云栖快讯】你想见的Java技术专家都在这了，向大佬提问，有问题必答 详情请点击
- 分享到:
