EAS8.5 创建数据表空间及恢复表空间
CREATE DIRECTORY dmpdir as 'E:\DBDATAFIEL\kingdee_eas_oracle';
create temporary tablespace EAS_T_NSL_TEMP tempfile 'E:\DBDATAFIEL\kingdee_eas_oracle\EAS_T_NSL_TEMP.dbf' size 100m autoextend on next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_NSL_TEMP2 datafile 'E:\DBDATAFIEL\kingdee_eas_oracle\EAS_D_NSL_TEMP2.dbf' size 100m autoextend on next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_NSL_INDEX datafile 'E:\DBDATAFIEL\kingdee_eas_oracle\EAS_D_NSL_INDEX.dbf' size 100m autoextend on next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_NSL_STANDARD datafile 'E:\DBDATAFIEL\kingdee_eas_oracle\EAS_D_NSL_STANDARD.dbf' size 100m autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
create user kdnsl IDENTIFIED BY kingdee DEFAULT TABLESPACE EAS_D_NSL_STANDARD TEMPORARY TABLESPACE EAS_T_NSL_TEMP ACCOUNT UNLOCK;
GRANT CONNECT,RESOURCE,DBA TO kdnsl;
impdp system/Xajxnm123@orcl directory=dmpdir dumpfile=NEWDB850BC.DMP table_exists_action=replace remap_tablespace=EAS_D_NEWDB850BC_STANDARD:EAS_D_NSL_STANDARD,EAS_T_NEWDB850BC_TEMP:EAS_T_NSL_TEMP REMAP_SCHEMA=NEWDB850BC:kdnsl job_name=nsl_impdp exclude=statistics LOGFILE=impdp180814.log
--删除表空间
drop tablespace EAS_T_NSL_TEMP including contents and datafiles cascade constraint;
drop tablespace EAS_D_NSL_TEMP2 including contents and datafiles cascade constraint;
drop tablespace EAS_D_NSL_INDEX including contents and datafiles cascade constraint;
drop tablespace EAS_D_NSL_STANDARD including contents and datafiles cascade constraint;
--删除用户
drop user kdnsl cascade;
EAS8.5 创建数据表空间及恢复表空间
本文2024-09-16 22:19:14发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-47384.html