alter tablespace ts_name autoextend_clause

alter tablespace ts_name autoextend_clause


This clause is valid only for bigfile (single-file) tablespaces. Use this clause to enable or disable autoextension of the single data file in the tablespace. To enable or disable autoextension of a newly added data file or temp file in smallfile tablespaces, use the autoextend_clause of the database_file_clauses in the ALTER DATABASE statement


[oracle@rac1 ~]$ sqlplus  /nolog


SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 18 22:37:12 2018


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


SQL> connect / as sysdba
Connected.
SQL> create tablespace ts_smallfile datafile '/s01/oracle/oradata/orcl/small.dbf' size 5m;


Tablespace created.


SQL> alter tablespace ts_smallfile autoextend on next 5m;
alter tablespace ts_smallfile autoextend on next 5m
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace TS_SMALLFILE




SQL> create bigfile tablespace ts_bigfile datafile '/s01/oracle/oradata/orcl/bigfile1.dbf' size 5m;


Tablespace created.


SQL> alter tablespace ts_bigfile autoextend on next 5m;


Tablespace altered.


SQL> alter database datafile '/s01/oracle/oradata/orcl/small.dbf' autoextend on next 5m;


Database altered.


SQL>