分享EAS860demo账套的用户名和表空间及导入方式

备份文件：EAS860UPD20191226.DMP

备份文件位置：EAS Cloud v8.6客户端.rar——DemoDC——EAS860UPD20191226.DMP.gz解压缩

demo账套的用户：EAS860UPD 

永久表空间：EAS_D_EAS860UPD_STANDARD

临时表空间：EAS_T_EAS860UPD_STANDARD

**********************************************************************************************************************

创建表空间及用户授权

create temporary tablespace EAS_T_easxin_STANDARD tempfile '/oradata/orcl/EAS_T_easxin_STANDARD.dbf' size 100m autoextend on next 50m maxsize UNLIMITED extent management local;

create tablespace EAS_D_easxin_STANDARD datafile '/oradata/orcl/EAS_D_easxin_STANDARD.dbf' size 100m autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create tablespace EAS_D_easxin_INDEX datafile '/oradata/orcl/EAS_D_easxin_INDEX.dbf' size 100m autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create tablespace EAS_D_easxin_TEMP2 datafile '/oradata/orcl/EAS_D_easxin_TEMP2.dbf' size 100m autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create user easxin IDENTIFIED BY kingdee DEFAULT TABLESPACE EAS_D_easxin_STANDARD TEMPORARY TABLESPACE EAS_T_easxin_STANDARD ACCOUNT UNLOCK;

GRANT CONNECT,RESOURCE,DBA TO easxin;

create or replace directory dmpdir as '/oradata/backup';

grant read,write on directory dmpdir to easxin;

***********************************************************************************************************************

导入测试数据：

impdp easxin/kingdee directory=dmpdir dumpfile=EAS860UPD20191226.DMP table_exists_action=replace REMAP_SCHEMA=EAS860UPD:easxin remap_tablespace=EAS_D_EAS860UPD_STANDARD:EAS_D_easxin_STANDARD,EAS_D_EAS860UPD_INDEX:EAS_D_easxin_INDEX,EAS_D_EAS860UPD_TEMP2:EAS_D_easxin_TEMP2 job_name=easxin_impdp  EXCLUDE=TABLE:\"LIKE\'VT%\'\"  exclude=statistics LOGFILE=impdp20200401.log  parallel=4

***********************************************************************************************************************

PS：EAS8.5demo账套的用户名和表空间及导入方式见这个帖子：https://vip.kingdee.com/article/43437547444568202