Oracle创建用户表空间

--创建表空间

create tablespace test

datafile 'D:\oracle\oradata\test\test.dbf'

size 100M autoextend on next 10M maxsize unlimited extent management local;

 

--创建用户并制定表空间

create user username identified by password  

default tablespace user_data  

temporary tablespace user_temp;  

 

--对用户授权

grant connect,resource,dba to Username;