Oracle CREATE TABLE Space __oracle

Oracle Create Tablespace

Url:http://www.cnblogs.com/netsql/articles/1745978.html

/* is divided into four steps *
///////* 1th: Create temporary table Space  * * *
temporary tablespace user_temp  
tempfile ' D:\oracle\oradata\ ORACLE9I\USER_TEMP.DBF ' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 
/* 2nd step: Create datasheet Space  * *
tablespace user_data  
logging  
datafile ' D:\oracle\oradata\Oracle9i\user _DATA.DBF ' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 
/* 3rd step: Create user and specify table space */create username
username identified by password  
default tablespace user_data  
Temporary tablespace user_temp;  
 
/* 4th step: Give the user permission  * * Grant
CONNECT,RESOURCE,DBA to username;