Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01114: IO error writing block to file

Guess2Apr 14 2008 — edited Apr 15 2008
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2008
Added on Apr 14 2008
4 comments
1,777 views