oracle 表空间

create temporary tablespace user_temp 

tempfile 'C:\app\joey\oradata\orcl\user_temp.dbf'

size 50m 

autoextend on 

next 50m maxsize 20480m 

extent management local; 


create tablespace user_data 

logging

datafile 'C:\app\joey\oradata\orcl\user_data.dbf'

size 50m 

autoextend on 

next 50m maxsize 20480m 

extent management local; 


drop user joey;

create user joey identified by   Passw0rd

default tablespace user_data 

temporary tablespace user_temp; 


grant connect,resource,dba to joey;