querying the table space in the current database whether to expand automatically
Select tablespace_name,file_name,autoextensible from Dba_data_files;
To automatically expand the table space by modifying the data file for the tablespace, and limit the maximum file size
ALTER DATABASE datafile '/OPT/APP/ORACLE/ORADATA/CAACDB/SYSTEM01.DBF ' autoextend on NEXT 50M maxsize 31G;
ALTER DATABASE datafile '/OPT/APP/ORACLE/ORADATA/CAACDB/UNDOTBS01.DBF ' autoextend on NEXT 50M maxsize 31G;
ALTER DATABASE datafile '/OPT/APP/ORACLE/ORADATA/CAACDB/SYSAUX01.DBF ' autoextend on NEXT 50M maxsize 31G;
ALTER DATABASE datafile '/OPT/APP/ORACLE/ORADATA/CAACDB/USERS01.DBF ' autoextend on NEXT 50M maxsize 31G;
. Summary modification Statement syntax
Turn on automatic extended function syntax:
ALTER DATABASE datafile ' corresponding data file path information ' autoextend on;
Turn off automatic extended functionality syntax:
ALTER DATABASE datafile ' corresponding data file path information ' autoextend off;