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

Following error arose, check data tablespace, there's sufficent free space. There's high probability that this error is due to database unix box disk space. We know the nature of oracle temp tablespace that when space added to temp space it does not allocate physical space, take only when required . The temp mount point is of 15Gb and the tempfile created is of 40GB, So as 15GB size usage reached it throws an error of No space left on device . I guess if the temp space is small, oracle will try to overwrite the tempspace, if it's big, it will access the full space allocated initially.

when reach 15 if allocated 40, then oracle try to access more space and fail if no space left, but if alocated 15 and have only 15, then it will rewrite. delete the tempfiles, and recreate the tempfiles, allocating 15G to temp tablespace. Rerun application, it's fine this time.

[@more@]03 Jun 09 13:54:17 FEED ERROR Error occurred running feed : java.sql.SQLException: ORA-01114: IO error writing block to file (block # )
ORA-06512: at line 1
ORA-06512: at "OWNER.P_EXP", line 223
ORA-06512: at "OWNER.P_FED", line 2804
ORA-01114: IO error writing block to file 202 (block # 246597)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 114688
ORA-01114: IO error writing block to file 202 (block # 246597)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 114688
ORA-06512: at line 1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14377/viewspace-1022776/，如需转载，请注明出处，否则将追究法律责任。