1. View the path to the data file store in the tablespace and whether it can be automatically extended
SELECT Tablespace_name, bytes/1024/1024 file_size_mb, file_name from Dba_data_files;
2. Set temporary data files to auto-expand
ALTER DATABASE Tempfile '/OPT/ORACLE/ORADATA/TEST/TEMP01.DBF ' autoextend on next 5m MaxSize Unlimited;
The extension table times is the following error
ERROR at line 1:ora-00376:file 201 cannot is read at this time
Ora-01110:data file 201: '/OPT/ORACLE/ORADATA/TEST/TEMP01.DBF '
3. View the status of a staging table
Select Name,status from V$tempfile
The reason: The temporary tablespace does not know what the reason is offline. Modified to online after successful modification
ALTER DATABASE Tempfile '/OPT/ORACLE/ORADATA/TEST/TEMP01.DBF ' online;
Database altered. Once again, the 2nd is OK.
Unable to extend temp segment by 128 (in Tablespace temp)