Oracle establishes table spaces and users

1. The first step,

First look at the storage path of the variable space

--View Tablespace file path
Select Tablespace_name,file_id,bytes/1024/1024,file_name
From Dba_data_files order by file_id;

2. Execute create temporal tablespace statement

      create temporary tablespace user_temp 
      tempfile Span style= "color: #ff0000;" > '

< Span style= "color: #000000;" >      create tablespace user_data 
      logging 
     datafile "d:\oracle\oradata\oracle9i\user_data.dbf '
    size 50m 
    autoextend on 
    next 50m maxsize 20480m 
    Extent Management local;

< Span style= "color: #008080;" > 4: Create user and specify tablespace  
create user username identified by password 
default tablespace user_data 
temporary tablespace user_temp;  

5: Grant permissions to users  
grant connect,resource,dba to username;

Oracle establishes tablespaces and users