Creating tablespaces using sqlplus

Create regular tablespaces:

CREATE TABLESPACE sj_data
DATAFILE '/u01/app/oracle/oradata/street/sj_data.dbf'
SIZE 10M reuse
AUTOEXTEND ON NEXT 10M

CREATE TABLESPACE sj_default
DATAFILE '/u01/app/oracle/oradata/street/sj_default.dbf'
SIZE 10M reuse
AUTOEXTEND ON NEXT 10M

CREATE TABLESPACE sj_index
DATAFILE '/u01/app/oracle/oradata/street/sj_index.dbf'
SIZE 10M reuse
AUTOEXTEND ON NEXT 10M

Finally, create the TEMPORARY tablespace:

create temporary tablespace sj_temp
tempfile '/u01/app/oracle/oradata/street/sj_temp.dbf'
size 10M reuse
AUTOEXTEND ON NEXT 10M