oracle创建表空间用户授权及sde服务创建

create tablespace halfayadb logging datafile ‘D:\app\Administrator\oradata\orcl\halfayadb.dbf‘ size 50m autoextend on next 50m maxsize 20480m extent management local;

create user halfayadb identified by halfayadb default tablespace halfayadb;

grant dba,resource to halfayadb;

sdeservice -o create -d oracle,orcl -p sde -i esri_sde

esri_sde               5151/tcp

drop user ×× cascade

DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;

oracle创建表空间用户授权及sde服务创建

标签：