分享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://wenku.my7c.com/article/43437547444568202
导入测试数据的时候提示这个,是少什么配置文件吗
老师,能麻烦分享下EAS860UPD20191226.DMP的链接么,完整版客户端的压缩包一直下载不下来,谢谢了。
grant imp_full_database to easxin 还差这个!
https://vip.kingdee.com/questions/202768830643727104 遇到过类似问题吗?
分享EAS860demo账套的用户名和表空间及导入方式
本文2024-09-16 22:19:52发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-47454.html