oracle 导入dmp

2019独角兽企业重金招聘Python工程师标准>>>

1.导出命令 exp test/test123@xe file=/usr/oraclewdw/db171101.dmp

2.导入命令 imp test/test123@xe file=/usr/oraclewdw/db171101.dmp full=y

3.imp的时候，有关statistics的错误，statistics=none就可以了

4.表空间不存在时 创建对应的表空间
create tablespace SCJY  
logging  
datafile 'D:\app\Administrator\oradata\orcl\SCJY.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;

5.只导入指定的表
imp.exe log=D:\oraclimp4.log file=E:\20171031.dmp userid=test/test@xx.xx.xx.xx/orcl fromuser=SCJY touser=test buffer=30720 commit=no grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes TABLES=YSZJ1,YSZJ2
 

转载于:https://my.oschina.net/dajianguo/blog/1570725