1、导入导出步骤:
1.创建目录(用于存放导出数据)mkdir 目录名
2.给目录授权:chown -R oracle testorcl
chown -R anychat:anychat *
3.su - oracle到oracle 用户下->sqlplus
4.create directory +虚拟目录 as '实际存放数据目录'
5,grant read,write on directory 虚拟目录 to 用户
6,exit(退出sql*plus)
7. oracle用户下执行expdp user/pw directory=虚拟目录 dumpfile=XXX.dmp logfile=xxxxx.log schemas=user
(expdp crh_new/wskh directory=WLZQTEST1 dumpfile=0422.dmp logfile=0422.log schemas=crh_new)
例如:
1.mkdir /opt/oracle/dpdmp
2.chown -R oracle dpdmp
3.su - oracle 然后 sqlplus
4.create directory DPDATA as '/opt/oracle/dpdmp'
5,grant read,write on directory DPDATA to wskh_uf
6,exit
7. expdp wskh_uf/wskh directory=DPDATA dumpfile=0422.dmp logfile=0422.log schemas=wskh_uf
impdp wskh_uf/wskh directory=DPDATA dumpfile=0422.dmp logfile=0422.log remap_schema=wskh_uf:wskh_uf1 remap_tablespace=crhdata:crhdata1;