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