准备工作
需要dmp文件、表空间名及用户名
还原步骤:
1.创建表空间
create tablespace ts_xxx
logging
datafile 'E:\app\xxx\oradata\orcl\xxx.DBF'
size 800m
autoextend on
next 100m maxsize 5120m
extent management local;
2.创建用户
create user user_xxx
identified by xxx
default tablespace ts_xxx;
3.给用户授权
grant connect,resource,dba to user_xxx;
4.执行imp命令
imp xxx/user_xxx@orcl file=D:\oracleDmp\dir\xxx.dmp tablespaces=ts_xxx full=y STATISTICS=NONE