Oracle之create tablespace、user

--创建数据表空间；
create tablespace home_data 
datafile 'D:\oracle\oradata\home\home_data.dbf'
size 20m
autoextend on
next 5m 
maxsize 50m--或者unlimited
extent MANAGEMENT LOCAL;


--创建索引表空间；以后创建索引时，要制定使用索引表空间；
create tablespace home_index
datafile 'D:\oracle\oradata\home\home_index.dbf'
size 20m
autoextend on
next 5m 
maxsize 50m--或者unlimited
extent MANAGEMENT LOCAL;




--创建临时表空间；
create temporary tablespace home_temp
tempfile 'D:\oracle\oradata\home\home_temp.dbf'
size 20m
autoextend on
next 5m 
maxsize 50m--unlimited
extent MANAGEMENT LOCAL;


--创建角色；
create role homeuser;


--赋权；
grant create session to homeuser;
grant create table to homeuser;
grant create view to homeuser;
grant create procedure to homeuser;
grant create sequence to homeuser;


--创建用户；
create user home identified by XXXX
default tablespace home_data
temporary tablespace home_temp quota umlimited on home_data;


--给用户赋角色；
grant homeuser to home;
grant unlimited tablespace to home;