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 %s (block # %s)

501173Aug 24 2006 — edited Mar 4 2010

Hi,

I tried to perform a complex select and a complex insert statement on Oracle9i Enterprise Edition Release 9.2.0.4.0 on my linux. The following error messages were displayed:

select statement: ORA-01114: IO error writing block to file %s (block # %s)
insert statement: ORA-00603: ORACLE server session terminated by fatal error

I did researches on the internet and found one of the causes (database's temp file space has filled up etc.), but I am not sure what to do.

I think that I found the temp file in the database directory: temp01.dbf (11.039.416.320). Is it the temp file mentioned? How can I truncate it? or what should I do with this file? What does this temp file do?

Another file is undotbs01.dbf (2.422.218.752). This is a big file. Should I fix this file?

Could someone please help me to solve this problem?
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2010

Added on Aug 24 2006

#general-database-discussions, #linux

29 comments

26,052 views