Oracle CREATE TABLE Space Step code _oracle

/* 1th step: Create 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;

/* 2nd step: Create a datasheet 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;

/* 3rd step: Create user and specify Tablespace/
Create user username identified by password
Default Tablespace user_data
Temporary tablespace user_temp;

/* 4th step: Granting user permission
Grant CONNECT,RESOURCE,DBA to username;