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;