oracle创建用户，表空间，虚拟路径，导入dbf

创建表空间

CREATE TABLESPACE oes
LOGGING  
DATAFILE 'D:\program\app\wbpc0185\oradata\oes\OES.DBF'  
SIZE 1024M   
AUTOEXTEND ON   
NEXT 32M MAXSIZE 2048M  
EXTENT MANAGEMENT LOCAL;  

创建用户

create user oes identified by oes  
DEFAULT TABLESPACE oes;  

赋予权限

grant connect,resource to oes;  
grant create session,dba to oes; 

创建虚拟路径

create or replace directory oracle_dir as 'd:/program/oracle_dmp_dir';

赋权

Grant read,write on directory oracle_dir to oes;

导入

impdp oes/oes  directory=oracle_dir dumpfile=OES_HR0619BAK.DMP logfile=0621b.log remap_schema=OES_HR0619:oes remap_tablespace=OES_HR0619:oes