Oracle creates table spaces

/*Divided into four steps*//*1th Step: Create a temporary table space*/CreateTemporaryTablespace user_temp Tempfile‘D:\oracle\oradata\Oracle9i\user_temp.dbf‘Size 50m AutoextendOnNext50m maxsize 20480m extent management local;/*2nd step: Create a data table space*/CreateTablespace user_data Logging DataFile‘D:\oracle\oradata\Oracle9i\user_data.dbf‘ size 50m autoextend on  50m maxsize 20480m extent management local; /* 3rd step: Create a user and specify tablespace */< Span style= "color: #0000ff;" >create user username identified by password default tablespace user_data temporary tablespace user_temp; /* 4th: Grant permissions to users */grant connect,resource,dba to username;        

Oracle Create tablespace