分享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://wenku.my7c.com/article/202759463722312192?productLineId=8
PS：EAS8.5demo账套的用户名和表空间及导入方式见这个帖子：https://wenku.my7c.com/article/43437547444568202
演示demo哪里有？
安装包里面好像，找不到DEMO文件
分享EAS88DEMO账套的用户名和表空间及导入方式
本文2024-09-16 22:37:41发表“eas cloud知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-eas-49327.html
