oracle中数据泵只导出索引,oracle expdp/impdp exclude=STATISTICS

在源库上expdpcreate directory dir_dp as 'd:\';Grant read,write on directory dir_dp to user;expdp user/password DIRECTORY=dir_dp DUMPFILE=exp_%U.dmp LOGFILE=exp_eb.log SCHEMAS=user exclude=STATISTICS  parallel=4注意必须排除统计值，否则impdp会报错。注意不须要排除索引，排除索引手工建索引很麻烦，还不如不用，impdp 只要并行度足够，建索引会很是快。在目标库上impdpdrop user user cascade;  清空数据CREATE TABLESPACE YKSPACE DATAFILE'F:\oradata\hr\hr01.dbf' SIZE 5000M AUTOEXTEND ON NEXT 50M MAXSIZE 10000MLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTOFLASHBACK ON;CREATE USER userIDENTIFIED BY passwordDEFAULT TABLESPACE YKSPACETEMPORARY TABLESPACE TEMPPROFILE DEFAULTACCOUNT UNLOCK;GRANT DBA TO user;GRANT CONNECT TO user;ALTER USER user DEFAULT ROLE ALL;GRANT UNLIMITED TABLESPACE TO user;create directory DUMP_DIR3 as 'f:\';Grant read,write on directory DUMP_DIR3 to user;拷贝源库上导出的文件到目标系统的F盘上impdp user/password DIRECTORY=DUMP_DIR3 DUMPFILE=EXP_%U.DMPLOGFILE=imp_eb.log SCHEMAS=user  parallel=40注意EXP_%U.DMP以前是小写的，可是会自动变成大写的。注意导入导出的并行度能够不同最后收集统计信息exec dbms_stats.gather_schema_stats(ownname => 'USER',options => 'GATHER AUTO');若是在导入大表的时候报错，能够单独导入导出这张表expdp   system/密码    DIRECTORY=dir_dp tables=SRM.PROPODETAILPLAN   DUMPFILE=d:\PROPODETAILPLAN_%U.dmp parallel=10impdp   system/密码   DIRECTORY=DUMP_DIR3 tables=SRM.PROPODETAILPLAN   file=/oracle/PROPODETAILPLAN_%U.dmp parallel=40 CONTENT=DATA_ONLY  若是表已经存在了能够加上CONTENT=DATA_ONLY  只导入数据。注意若是已经导入了部分数据在没有导入索引的状况下会插入重复数据，因此必须先truncate table SRM.PROPODETAILPLANweb