SQL> alter database tempfile '/opt/oracle/oradata/TEST/temp01.dbf' autoextend on next 5m maxsize unlimited;
alter database tempfile '/opt/oracle/oradata/TEST/temp01.dbf' autoextend on next 5m maxsize unlimited
*
ERROR at line 1:
ORA-00376: file 201 cannot be read at this time
ORA-01110: data file 201: '/opt/oracle/oradata/TEST/temp01.dbf'
原因是临时表空间不知道什么原因offline了，修改为online后修改成功。
SQL> alter database tempfile '/opt/oracle/oradata/TEST/temp01.dbf' online;
Database altered.