To Creates and adds a datafile to a tablespace:
ALTER TABLESPACE ... ADD DATAFILE
Creates and adds a tempfile to a temporary tablespace
ALTER TABLESPACE ... ADD TEMPFILE
Creates a database and associated datafiles
CREATE DATABASE