Example code for creating a tablespace in Oracle

The following articles describe how to create a table space in Oracle and how to create a user's code description to analyze how to create a table space in Oracle and how to create a user's actual application. The following is a detailed description of the database, I hope you will understand this article after reading it.

Create temporary tablespace

 
 

  
  
create temporary tablespace test_temp   
  
  
tempfile 'E:\Oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'   
  
  
size 32m   
  
  
autoextend on   
  
  
next 32m maxsize 2048m   
  
  
extent management local;  
 
 

Create a data table space

 
 

  
  
create tablespace test_data   
  
  
logging   
  
  
datafile 'E:\Oracle\product\10.2.0\oradata\testserver\test_data01.dbf'   
  
  
size 32m   
  
  
autoextend on   
  
  
next 32m maxsize 2048m   
  
  
extent management local;  
 
 

Create a user and specify a tablespace in Oracle

 
 

  
  
create user username identified by password   
  
  
default tablespace test_data   
  
  
temporary tablespace test_temp;  
 
 

Grant permissions to users

 
 

  
  
grant connect,resource to username; 
 
 

The preceding content describes how to create a tablespace and user-related code in Oracle, hoping to help you in this aspect.