how-to-add-a-datafile-to-a-tablespace.md

How to add a datafile to a tablespace

The following example enables automatic extension for a datafile added to the users tablespace:

ALTER TABLESPACE users
    ADD DATAFILE '/home/mijin/test_data/users02.dbf' SIZE 1000M
      AUTOEXTEND ON
      MAXSIZE UNLIMITED;