OraFAQ Forum: Server Administration » ORA-01114: IO error writing block to file %s (block # %s)

Home » RDBMS Server » Server Administration » ORA-01114: IO error writing block to file %s (block # %s)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01114: IO error writing block to file %s (block # %s) [message #145583]

Thu, 03 November 2005 22:28

gjayasekar
Messages: 45
Registered: October 2005

Member

hi,

i am using a query to find the duplicate values in the table then i got this error

ORA-01114: IO error writing block to file %s (block # %s)

what is this and pl tell me how to solve it

Regards

Jai

Report message to a moderator

Re: ORA-01114: IO error writing block to file %s (block # %s) [message #145607 is a reply to message #145583]

Fri, 04 November 2005 02:55

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

ORA-01114: IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
Action: Restore access to the device or remove unnecessary files to free up space.

Report message to a moderator

Previous Topic:	images wanted for presentation
Next Topic:	ORA-00600

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:30:33 CST 2025