Oracle tablespace Adding and Dropping Datafiles and Tempfiles

Adding and Dropping Datafiles and Tempfiles: Examples The following statement adds a datafile to the tablespace. When more space is needed, new 10-kilobytes extents will be added up to a maximum of 100 kilobytes:

ALTER TABLESPACE tbs_03 
    ADD DATAFILE 'tbs_f04.dbf'
    SIZE 100K
    AUTOEXTEND ON
    NEXT 10K
    MAXSIZE 100K;

The following statement drops the empty datafile:

ALTER TABLESPACE tbs_03
    DROP DATAFILE 'tbs_f04.dbf';