Article From:https://www.cnblogs.com/yss669/p/9967441.html

The following statement can be executed in PLSQL tool to establish Oracle table space. — forwarding

 

/*Divided into four steps * /
/*Step 1: Create temporary table spaces*/
create temporary tablespace yuhang_temp 
tempfile ‘D:\oracledata\yuhang_temp.dbf’ 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 
/*Step 2: Create a data table space */
create tablespace yuhang_data  
logging  
datafile ‘D:\oracledata\yuhang_data.dbf’ 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 
/*Step 3: Create users and specify table spaces */
create user yuhang identified by yuhang  
default tablespace yuhang_data  
temporary tablespace yuhang_temp;  
 
/*Step 4: Give users permission */
grant connect,resource,dba to yuhang;

Leave a Reply

Your email address will not be published. Required fields are marked *