You are right Pando.. I have not created this database and I just started in this place.. If you look at original message, it shows as though Temp has 2.8GB, but truly (checking datafiles) I could see allocation of 4 datafiles equalling 3.8GB and I am wondering why 1 GB is not available..

Please look at my findings..

1 select substr(tablespace_name, 1,10) tablespace, substr(file_name, 1,30) file_name, file_id,
2 bytes, status, autoextensible, user_bytes, user_blocks
3* from dba_temp_files
SQL> /


TABLESPACE FILE_NAME FILE_ID BYTES STATUS AUT USER_BYTES USER_BLOCKS
---------- ------------------------------ ---------- ---------- --------- --- ---------- -----------
TEMP /u03/dbs/ODBMSPRD/temp01.dbf 1 1048576000 AVAILABLE NO 1047527424 127872
TEMP /u09/dbs/ODBMSPRD/temp02.dbf 2 AVAILABLE
TEMP /u07/dbs/ODBMSPRD/temp03.dbf 3 1048576000 AVAILABLE NO 1047527424 127872
TEMP /u12/dbs/ODBMSPRD/temp04.dbf 4 838860800 AVAILABLE NO 837812224 102272


For the fileID 2, it shows as available but no bytes shown..

From unix:

oracle@CG_JDA1:/u09/dbs/ODBMSPRD_> ls -l t*.dbf
-rw-r----- 1 oracle dba 1048584192 May 30 11:00 temp02.dbf

what does this mean? Where is the 1GB allocated to fileID 2.

Thanks, ST2000