create tablespace CAACSC_DAT
logging
datafile 'F:\DB\CAACSC\CAACSC_DAT.DBF'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create user caacsc identified by caacsc
default tablespace CAACSC_DAT;
GRANT UNLIMITED TABLESPACE TO caacsc;
grant create session,resource to caacsc;
创建表空间
create tablespace MSKY_DAT
logging
datafile 'F:\NEWDB\MSKY\MSKY_DAT.DBF'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
删除表空间
drop tablespace MSKY_DAT including contents
创建用户并指定表空间
create user R_SELMSKY identified by SA
default tablespace test_data
temporary tablespace test_temp;
修改用户的表空间
alter user MSKY quota unlimited on MSKY_DAT; 全部
为用户指定权限
GRANT UNLIMITED TABLESPACE TO MSKY
