Oracle: How do you add a data file to a tablespace?

Answer 1

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