请教大神们一下:
扩充临时表空间文件大小报错
SQL> alter database tempfile '/oradata/PCSDEV/temp01.dbf' resize 10240M;
alter database tempfile '/oradata/PCSDEV/temp01.dbf' resize 10240M
*
ERROR at line 1:
ORA-00376: file 1001 cannot be read at this time
ORA-01110: data file 1001: '/oradata/PCSDEV/temp01.dbf'
SQL> !oerr ora 376
00376, 00000, "file %s cannot be read at this time"
// *Cause: attempting to read from a file that is not readable. Most likely
// the file is offline.
// *Action: Check the state of the file. Bring it online
然而 我的临时表空间却没有offline 这是什么原因呢？
SQL> SELECT * from DBA_TEMP_FILES;
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
/oradata/PCSDEV/temp01.dbf
1 TEMP AVAILABLE
SQL> select TABLESPACE_NAME,STATUS from DBA_TABLESPACES;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMP ONLINE
PREPAID_DATA_TS ONLINE
PREPAID_IDX_TS ONLINE
PREPAID_INF_TS ONLINE
求大神们赐教！！

建议检查临时文件的权限是否正常

看下 dba_data_file 视图 看看 数据文件是否正常。是否处于需要recovery状态。

dba_temp_files里面状态是正常的，但是大小为空
SQL> select FILE_NAME,BYTES,status from dba_temp_files;FILE_NAME-------------------------------------------------------------------------------- BYTES STATUS---------- ---------/oradata/PCSDEV/temp01.dbf AVAILABLE/oradata/PCSDEV/temp02.dbf5242880000 AVAILABLE
但是ls 命令查看却是存在大小的
SQL> !ls -l /oradata/PCSDEV/temp*
-rw-r----- 1 oracle oinstall 5242888192 Jun 21 09:13 /oradata/PCSDEV/temp01.dbf
-rw-r----- 1 oracle oinstall 5242888192 Jun 29 22:00 /oradata/PCSDEV/temp02.dbf