Detailed introduction to creating table space in oracle

Notes:
1. If you open it in a tool such as PL/SQL, directly modify the [italic and bold part] in the following code to execute
2. Make sure the path exists, such as [D:\oracle \oradata\Oracle9i\] That is, the path where you want to save the file exists
/*It is divided into four steps*/
/*Step 1: Create a temporary table space*/

create temporary tablespace user_temp 
tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf' 
size 50m 
autoextend on 
next 50m maxsize 20480m 
extent management local;

/* Step 2: Create a data table space*/

create tablespace user_data 
logging 
datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf' 
size 50m 
autoextend on 
next 50m maxsize 20480m 
extent management local;

/*Step 3: Create a user and specify the table space*/

create user username identified by password 
default tablespace user_data 
temporary tablespace user_temp;

/*Step 4: Grant permissions to the user*/

grant connect,resource,dba to username;

For more detailed introduction to oracle table space creation and related articles, please pay attention to the PHP Chinese website!