首先清理以前还原过的痕迹
drop user dwuser cascade;
drop tablespace hfdb;
创建临时表空间
CREATE TEMPORARY TABLESPACE hfdb_temp
TEMPFILE 'e:/data/hfdb_temp.dbf '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
创建表空间
CREATE TABLESPACE DWZH_TBS
LOGGING
DATAFILE 'e:/data/hfdb.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
创建用户
CREATE USER TUSER IDENTIFIED BY TUSER
DEFAULT TABLESPACE DWZH_TBS
TEMPORARY TABLESPACE hfdb_temp;
授权
grant connect,resource,dba to TUSER;
最后导入dmp文件:在CMD输入
imp dwuser/dwuser@orcl full=y file=e:/data/oracle.dmp ignore=y log =e:/data/log.txt;
或者使用PLSQL工具导入 直接选择dmp文件