一、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