|
|
| Re: ORA-01114: IO error writing block to file %s (block # %s) [message #146784 is a reply to message #146734] |
Sun, 13 November 2005 23:00   |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| Quote: |
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.
|
"group by" needs space in temporary tablespace for sorting.
It might be the case with you.
[Edit: Always remember to mention OS version and Oracle version]
[Updated on: Sun, 13 November 2005 23:02] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
