使用dmp文件恢复oracle数据库的数据

1、创建表空间

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

create tablespace jxny datafile '.dbf' size 500M autoextend on maxsize unlimited;

2、创建用户（与到处时的用户名一致）

create user 用户名
identified by 密码 
default  tablespace 表空间 
temporary tablespace TEMP 

profile DEFAULT;

create user jxny
identified by abcdef
default tablespace jxny
temporary tablespace TEMP
profile DEFAULT;

3、对用户进行授权

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 jxny with admin option ;  
grant dba to jxny with admin option;  
grant unlimited tablespace to jxny with admin option;  
grant create session to jxny; 

4、进行数据库导入（以上命令要在sqlplus中执行，而导入导出命令要在cmd中执行）

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

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