查看Oracle表空间是否自动扩展

非临时表空间：

select file_id from dba_data_files where tablespace_name=;

alter database datafile autoextend on next 10M maxsize 10G;

临时表空间：

select file_id from dba_temp_files where tablespace_name=;

alter database tempfile autoextend on next 10M maxsize 10G;