--创建临时表空间
create temporary tablespace test_temp
tempfile '/spsytest/test_temp01.dbf'
size 100m
autoextend on
next 100m maxsize 30000m
extent management local;
--创建数据表空间
create tablespace test_spsy
logging
datafile '/spsytest/test_spsy01.dbf'
size 100m
autoextend on
next 100m maxsize 30000m
extent management local;
--增加表空间数据文件
alter tablespace test_spsy
add datafile '/spsytest/test_spsy02.dbf'
size 100m
autoextend on
next 100m maxsize 30000m
表空间单个数据文件最大为32G
--创建用户并指定表空间
create user gdyj_spsy identified by tiger
default tablespace test_spsy
temporary tablespace test_temp;
--授予权限
grant connect, resource to gdyj_spsy;