oracle创建表空间、用户

//创建临时表空间 

create temporary tablespace tpts_temp 
tempfile 'D:\oracle\product\10.2.0\oradata\orcl\tpts_temp01.dbf' 
size 32m 
autoextend on 
next 32m maxsize 2048m 
extent management local; 

//创建数据表空间 
create tablespace ts_name 
logging 
datafile 'D:\oracle\product\10.2.0\oradata\orcl\ts_name01.dbf' 
size 32m 
autoextend on 
next 32m maxsize 2048m 
extent management local; 

//创建用户并指定表空间 
create user username identified by password 
default tablespace  ts_name  
temporary tablespace tpts_temp; 

//给用户授予权限 

grant connect,resource to username;