Alter Tablespace Add Datafile

Example, How to add datafile in existing table.

ALTER TABLESPACE

USERS

ADD DATAFILE

‘/ora01/oracle/oradata/users_01.dbf’

SIZE 2560M AUTOEXTEND ON NEXT 10M MAXSIZE 5000M;