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

导出方式 expdp

账套用户名：EAS88DEMO，密码123456

永久表空间名称：EAS_D_EAS88DEMO_STANDARD，临时表空间名称：EAS_T_EAS88DEMO_STANDARD。

版本号是：Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production。

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

创建表空间、用户、授权

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

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

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

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

create user EAS88DEMO IDENTIFIED BY 123456 DEFAULT TABLESPACE EAS_D_EAS88DEMO_STANDARD TEMPORARY TABLESPACE EAS_T_EAS88DEMO_STANDARD ACCOUNT UNLOCK;

GRANT CONNECT,RESOURCE,DBA TO EAS88DEMO;

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

grant read,write on directory dmpdir to EAS88DEMO;

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

导入数据：

impdp EAS88DEMO/123456 directory=dmpdir dumpfile=EAS88DEMO.DMP table_exists_action=replace REMAP_SCHEMA=EAS88DEMO:EAS88DEMO remap_tablespace=EAS_D_EAS88DEMO_STANDARD:EAS_D_EAS88DEMO_STANDARD,EAS_D_EAS88DEMO_INDEX:EAS_D_EAS88DEMO_INDEX,EAS_D_EAS88DEMO_TEMP2:EAS_D_EAS88DEMO_TEMP2 job_name=EAS88DEMO_impdp  EXCLUDE=TABLE:\"LIKE\'VT%\'\"  exclude=statistics LOGFILE=impdp20221102.log

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

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

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