还原oracle数据库备忘

--创建表空间
CREATE SMALLFILE TABLESPACE "GTDB8TEST" DATAFILE 'D:/ORADATA/ORCL/GTDB8TEST.DBF' 
 SIZE 100M 
 AUTOEXTEND ON NEXT 100M 
 MAXSIZE UNLIMITED 
 LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
 
--创建用户
CREATE USER jserp IDENTIFIED BY jserp 
DEFAULT TABLESPACE  GTDB8TEST 
TEMPORARY TABLESPACE TEMP;


--用户赋权限1
grant connect,resource,dba to jserp;


--用户赋权限2
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
   DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
      DBA,CONNECT,RESOURCE,CREATE SESSION TO jserp;
      
--cmd执行导入还原数据库
imp jserp/jserp@orcl full=y file=D:/ORADATA/ORCL/201612161111.dmp ignore=y log=D:/ORADATA/ORCL/log.txt;