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

账套导出方式：expdp

账套用户名称：EAS900DEMO，永久表空间名称：EAS_D_EAS900DEMO_STANDARD、临时表空间名称：EAS_T_EAS900DEMO_STANDARD

数据库版本号：Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

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

创建表空间、用户、授权

create temporary tablespace EAS_T_EAS900DEMO_STANDARD tempfile '/oracle/app/oradata/ORCL/EAS_T_EAS900DEMO_STANDARD.dbf' size 100m autoextend on next 50m maxsize UNLIMITED extent management local;

create tablespace EAS_D_EAS900DEMO_STANDARD datafile '/oracle/app/oradata/ORCL/EAS_D_EAS900DEMO_STANDARD.dbf' size 100m autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create tablespace EAS_D_EAS900DEMO_INDEX datafile '/oracle/app/oradata/ORCL/EAS_D_EAS900DEMO_INDEX.dbf' size 100m autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create tablespace EAS_D_EAS900DEMO_TEMP2 datafile '/oracle/app/oradata/ORCL/EAS_D_EAS900DEMO_TEMP2.dbf' size 100m autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create user EAS900DEMO IDENTIFIED BY 123456 DEFAULT TABLESPACE EAS_D_EAS900DEMO_STANDARD TEMPORARY TABLESPACE EAS_T_EAS900DEMO_STANDARD ACCOUNT UNLOCK;

GRANT CONNECT,RESOURCE,DBA TO EAS900DEMO;

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

grant read,write on directory dmpdir to EAS900DEMO;

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

导入数据：

impdp EAS900DEMO/123456 directory=dmpdir dumpfile=EAS900DEMO.DMP table_exists_action=replace job_name=EAS900DEMO_impdp  EXCLUDE=TABLE:\"LIKE\'VT%\'\"  exclude=statistics LOGFILE=impdp.log

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

PS：EAS8.8demo账套的用户名和表空间及导入方式见这个帖子：https://developer.kingdee.com/article/375642986438662144?productLineId=8&lang=zh-CN

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

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