ALTER TABLESPACE tablespace_name
AUTOEXTEND ON
NEXT 100M
MAXSIZE UNLIMITED;
This clause is valid only for bigfile (single-file) tablespaces. Use this clause to enable or disable autoextension of the single datafile in the tablespace. To enable or disable autoextension of a newly added datafile or tempfile in smallfile tablespaces, use the autoextend_clause
of the database_file_clauses in the ALTER
DATABASE
statement
MARK