linux系统下创建oracle表空间和用户权限查询

create temporary tablespace user_temp（临时表空间名称）  
tempfile "homeoracleapporadata/GSMRuser_temp.dbf"
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 

create tablespace user_data（数据表空间名称）  
logging  
datafile "homeoracleapporadataGSMRuser_data.dbf" 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 

create user username（用户名） identified by password（密码）  
default tablespace user_data  
temporary tablespace user_temp;  
 

grant connect,resource,dba to username;