数据泵导入导出操作方法

?---在原服务器（WINDOWN服务器）上D盘创建一个DataBak目录
sqlplus sys/oracle@orcl as sysdba
--创建数据泵目录
Create directory dp as 'd:\DataBak';
--授权用户
Grant read,write on directory dp to system;
grant exp_full_database to SYSTEM;
grant imp_full_database to SYSTEM;
--设置为不限制大小写
Alter System Set sec_case_sensitive_logon = false scope=both;
--设置为可以导出空表
Alter System Set deferred_segment_creation=false scope=both;
--设置为不限制密码效期
Alter Profile Default Limit Password_Life_Time Unlimited;

--在原服务器上导出数据泵数据
expdp 'sys/oracle as sysdba' DUMPFILE=expdp_full_%U.dmp DIRECTORY=dp LOGFILE=expdpfull.log FULL=y parallel=4


--把数据文件拷贝到新的服务器d:\DataBak目录，创建实例
--创建导入的数据泵目录
Create directory dp as 'd:\DataBak';
Grant read,write on directory dp to system;
grant exp_full_database to SYSTEM;
grant imp_full_database to SYSTEM;
execute DBMS_AUTO_TASK_ADMIN.DISABLE;
--设置为不限制大小写
Alter System Set sec_case_sensitive_logon = false scope=both;
--设置为可以导出空表
Alter System Set deferred_segment_creation=false scope=both;
--设置为不限制密码效期
Alter Profile Default Limit Password_Life_Time Unlimited;

---数据导入
impdp 'sys/oracle as sysdba' DUMPFILE=expdp_full1_%U.dmp directory=dp full=y LOGFILE=impdpfull.log parallel=8 exclude=SCHEMA:\" in ('SYS','SYSTEM','OUTLN','MGMT_VIEW','FLOWS_FILES','MDSYS','ORDSYS','EXFSYS','DBSNMP','WMSYS','WKSYS','WK_TEST','CTXSYS','ANONYMOUS','SYSMAN','XDB','WKPROXY','ORDPLUGINS','FLOWS_030000','OWBSYS','SI_INFORMTN_SCHEMA','OLAPSYS','SCOTT','ORACLE_OCM','TSMSYS','XS$NULL','MDDATA','DIP','APEX_PUBLIC_USER','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR')\"

--完成后编译无效对象