ORA-01114: IO error writing block to file
Guess2Apr 14 2008 — edited Apr 15 2008I am trying to create an index on a RAC database. I have tried this in two different schemas with two different tablespaces. I am not getting the standard "unable to extend segment" when you are out of space. I get:
Tried creating an index:
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
I actually lose connection to the database.
I checked udump and I get:
ksedmp: internal or fatal error
ORA-01114: IO error writing block to file 500 (block # 625225)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 625225)
Additional information: -1
1. I have 525 GBs of free space in one of my tablespace which is plenty
2. I was able to create a new table and copy the data from the existing table. Just getting the problem with creating indexes.
I do not have a file_id 500, so I guess that is an OS file number.