sqlplus导入dmp文件

//创建临时空间

create tablespace JNJP datafile 'd:\test.dbf' size 100m reuse autoextend on next 10m maxsize unlimited;

//创建用户并指定空间

create user jeesite identified by jeesite default tablespace JNJP temporary tablespace temp;

//授权

grant dba to jeesite;

grant connect,resource to jeesite;

//导入dmp文件，imp是cmd指令

imp jeesite/jeesite  file=D:\ch\jeesite20180504.dmp full=y ignore=y;