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!