ORACLE: Creating tablespaces

Scooped from here:

Normal a.k.a. Permanent a.k.a. Data

create tablespace {TABLESPACE-NAME}
  logging
  datafile 'C:\path\relative\to\oracle\server.dbf' 
  size 32m 
  autoextend on 
  next 32m maxsize 2048m
  extent management local;

Temporary

create temporary tablespace {TABLESPACE-NAME}
  tempfile 'C:\path\relative\to\oracle\server.dbf'
  size 32m
  autoextend on
  next 32m
  maxsize 2048m
  extent management local;

[Listening to: Disturbed - Stupify]