Data Pump

Data Pump

---

1. 创建目录对象并授权

mkdir work

create directory my_dir as '/home/oracle/work';
grant all on directory my_dir to system , YDCZ_YMXW;

1. 导出YDCZ_YMXW方案

 expdp system/oracle_4U@orcl directory=my_dir schemas=YDCZ_YMXW parallel=4 dumpfile=YDCZ_YMXW.dump compression=all;

……

1. 导入方案

create user yy identified by yy;
grant connect,resource to yy;

 impdp userid=system/oracle_4U@orcl directory=my_dir dumpfile=YDCZ_YMXW.dump schemas=YDCZ_YMXW remap_schema=YDCZ_YMXW:yy

1. 验证

conn yy/yy;
select  *  from tab;