Procedure for creating a user for Oracle table

Sqlplus scott/tigrt @ orcl

-- Connection
Conn/as sysdba;

-- Create a user
Create user zhao
Identified by zhao123
/

-- Authorization
Grant dba to zhao;

-- Create a tablespace
Create tablespace OA
Datafile 'e: \ Oracle \ lession1 \ OA. dbf ';
Size 20 M
Autoextend on next 10 m;
/
Note that you must specify the corresponding tablespace.
Modifies a specified tablespace.
Alter user username default tablespace tablespace_name
View the user's tablespace
Select t. username, t. profile, t. default_tablespace from dba_users t;