EAS850，Oracle版本的demo数据库恢复

标准demo数据库恢复，NEWDB850BC.DMP，demo数据库的表空间名称：EAS_D_NEWDB850BC_STANDARD

-- 1 创建表空间

create tablespace EAS_D_NEWDB850BC_STANDARD logging datafile 'E:\app\kingdee\oradata\orcl\EAS_D_NEWDB850BC_STANDARD.DBF' SIZE 100M autoextend on next 100M;

-- 2 创建用户并授权

create user NEWDB850BC identified by NEWDB850BC default tablespace EAS_D_NEWDB850BC_STANDARD;

grant connect, resource, imp_full_database to NEWDB850BC;

-- 3 创建数据泵文件夹目录

create or replace directory datafile_mdik as 'E:\app\kingdee\oradata\orcl';

grant read, write on directory datafile_mdik to NEWDB850BC;

-- 4 导入数据文件

impdp NEWDB850BC/NEWDB850BC@orcl DIRECTORY=datafile_mdik  dumpfile=NEWDB850BC.DMP logfile=mydmp.log FULL=y remap_schema=NEWDB850BC:easuser remap_tablespace=EAS_D_NEWDB850BC_STANDARD:EAS85SPACE;