oracle11g创建表空间命令

创建临时表空间 
create temporary tablespace yycg0730 
tempfile 'F:\OracleInstal\oradata\yycg\yycg0730.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 
创建数据表空间
create tablespace yycg0730  
logging  
datafile 'F:\OracleInstal\oradata\yycg\yycg0730.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 
创建用户并指定表空间 
create user yycg0730 identified by yycg0730
default tablespace yycg0730  
temporary tablespace temp;  
 
给用户授予权限  
grant connect,resource,dba to yycg0730