【亲测无误】Oracle数据泵导入数据库案例

1.创建表空间（包括临时表空间）

您暂时无权查看此隐藏内容！

2.添加表空间文件（包括临时表空间）

alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD01.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD02.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD03.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD04.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD05.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD06.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD07.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD08.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_STANDARD add datafile '/data2/oradata/EAS_D_ZLDCZS_STANDARD09.dbf' size 100m autoextend on next 50m maxsize UNLIMITED;

alter tablespace EAS_D_ZLDCZS_INDEX add datafile '/data2/oradata/EAS_D_ZLDCZS_INDEX01.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_INDEX add datafile '/data2/oradata/EAS_D_ZLDCZS_INDEX02.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_INDEX add datafile '/data2/oradata/EAS_D_ZLDCZS_INDEX03.dbf' size 100m autoextend on next 50m maxsize UNLIMITED; 
alter tablespace EAS_D_ZLDCZS_INDEX add datafile '/data2/oradata/EAS_D_ZLDCZS_INDEX04.dbf' size 100m autoextend on next 50m maxsize UNLIMITED;

alter tablespace EAS_T_ZLDCZS_STANDARD add tempfile '/data2/oradata/EAS_T_ZLDCZS_STANDARD01.dbf' size 100m autoextend on next 50m maxsize UNLIMITED;

3.创建用户

create user username identified by passwd;
grant resource,connect to username;

4.导入数据库操作

impdp system/Zldc**** directory=impdp dumpfile=zldczs20190116010001.dmp logfile=zldc20190117.log remap_schema=zldczs:eas20190116 TABLE_EXISTS_ACTION=REPLACE

温馨提示：帆帆帆帆法

Oracle数据泵导入导出数据库参考琼杰笔记文档：Oracle数据泵导入导出备份数据库数据详解