Data Pump

Data Pump

---

创建目录对象并授权 mkdir work

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

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

……

导入方案 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

验证 conn yy/yy; select * from tab;