Oracle数据库创建表空间、创建用户及授权

 

 

--GIS表空间创建脚本

CREATE TABLESPACE IMS

LOGGING

DATAFILE 'C:/oracle/product/10.2.0/oradata/PGISDB/IMS.ORA' SIZE 200M

EXTENT MANAGEMENT LOCAL SEGMENT

SPACE MANAGEMENT AUTO;

 

--GIS用户创建脚本

CREATE USER IMS PROFILE DEFAULT

IDENTIFIED BY "IMS" DEFAULT TABLESPACE IMS

ACCOUNT UNLOCK;

 

--授权

GRANT EXECUTE TO IMS;