PL/SQL表空间的建立及授权

/* 创建临时表空间 */
create temporary tablespace gsydtemp 
tempfile 'E:\oracle\oradata\GSYD\gsydtemp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

/* 创建数据表空间 */
create tablespace gsyd
logging
datafile 'E:\oracle\oradata\GSYD\gsyd.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

/* 创建用户并指定表空间 */
create user gsyd identified by gsyd
default tablespace gsyd
temporary tablespace gsydtemp;

/* 给用户授予权限 */
grant connect,resource to gsyd;