ORA-01114: IO error writing block to file

[7280]

Hi,
while i'm running a quey i get this error:
ERROR at line 2:
ORA-01114: IO error writing block to file 201 (block # 34057)
ORA-27072: skgfdisp: I/O error
Linux Error: 28: No space left on device
Additional information: 34056
ORA-01114: IO error writing block to file 201 (block # 34057)
ORA-27072: skgfdisp: I/O error
Linux Error: 28: No space left on device
Additional information: 34056

I have seen that one linux filesystem goes to 100% full and it's the one containing a tempfile. So i added on another filesystem a second tempfile and rerun the query but it's failing again with same error.
Using oracle 9.2.0.1 on linux redhat 7.2
Please advice me. Thanks
Tarek

 

[iq193]

The error message indicates that you do not have enough space in the datafiles associated with a tablespace. You can determine which tablespace is affected by querying DBA_DATA_FILES.

Adding a 2nd tempfile does not alleviate the problem. You must add the additional datafile to the affected tablespace not just create another temporary tablepace.

HTH,