oracle数据泵

一、directory 

1、创建directory 

create or replace directory directory_dir as 'E:\app\admin\oradata\directory';

2、查询directory 

select * from dba_directories;

3、授权

grant read,write on directory directory_dir to MZL;

二、导出导入

expdp mzl_proj/"""mzl123$%^"""@10.66.2.132:1521/mzldb directory=DATA_PUMP_DIR dumpfile=mzl.dmp schemas='mzl_proj'

impdp MZL/MZL@ORCL directory=directory_dir dumpfile=MZL.dmp remap_schema=mzl_proj:MZL remap_tablespace=TBS_TB_MZL:MZL NOLOGFILE=y