oracle 恢复dmp数据,Oracle数据库使用DMP文件恢复数据

1、创建还原所用的dmp所在的文件夹

create directory 文件夹名 as ‘/dir’

create directory backup as ‘backup’;

2、创建表空间

create tablespace 空间名 datafile ‘.dbf’size 500M autoextend on maxsize unlimited;

create tablespace liuwei datafile ‘.dbf’size 500M autoextend on maxsize unlimited;

3、创建用户(与导出时的用户名一致)

create user 用户名

identified by 密码

default  tablespace 表空间

temporary tablespace TEMP

profile DEFAULT;

create user Lavi

identified by Lavi

default tablespace LaviSpace

temporary tablespace TEMP

profile DEFAULT;

4、对用户进行授权

grant connect to 用户 with admin option ;

grant dba to 用户 with admin option;

grant unlimited tablespace to 用户 with admin option;

grant create session to 用户;

grant connect to Lavi with admin option ;

grant dba to Lavi with admin option;

grant unlimited tablespace to Lavi with admin option;

grant create session to Lavi;

5、进行数据库导入(以上命令要在sqlplus中执行，而导入导出命令要在cmd中执行)

导入要和导出的命令相对应，exp和imp，expdp和impdp

IMPDP USERID=’用户名/密码@实例 as sysdba’ directory=LOG_FILE_DIR dumpfile=20100816.dmp logfile=20100816.log