--临时表空间
create temporary tablespace TS_TEMP_BIDM
tempfile 'D:\app\oracle\oradata\dwdb\TS_TEMP_BIDM.dbf'
size 100m
autoextend on
next 250m maxsize unlimited
extent management local;
--默认表空间
create tablespace TS_BIDM
logging
DATAFILE 'D:\app\oracle\oradata\dwdb\TS_BIDM1.dbf'
size 100m
autoextend on
next 10m
maxsize unlimited
extent management local;
--创建用户并制定表空间,赋权限
create user username identified by password
default tablespace TS_BIDM
temporary tablespace TS_TEMP_BIDM;
grant CREATE SESSION , CREATE VIEW , RESOURCE to username ;
grant unlimited tablespace to username ;