|
|
ORA-01114: IO error writing block to file string (block #
string) tips
Oracle Error Tips by Donald Burleson(S. Karam)
|
The Oracle docs note this on the
ora-01114 error:
- 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.
You can pinpoint the tablespace and segment for
an ORA-01444 error by plugging-in the file_id and block_id into this query on
dba_extents:
select
owner,
tablespace_name,
segment_type,
segment_name
from
dba_extents
where
file_id = 1030
and
block_id = 602122;
In some cases, the ORA-01114 error occurs when a whole
disk or mount point is full. In this case, the ORA-01114 error is
accompanies by this message:
IBM AIX RISC System/6000 Error: 28:
No space left on device
Additional information: -1
Additional
information: 180224
ORA-01114 occurs when you attempt to write to a file and the device with the
file is either:
- offline OR
- has run out of space, possibly because it is a temporary file which was
not allocated at creation time.
To resolve ORA-01114, you should either:
- restore access to the device OR
- take out files which are not needed in order to gain more space
(depending on which problem your ORA_01114 is based)
The final step in clearing up ORA-01114 is to simply attempt to re-write the
file again.
Also note
this thread
where a user notes a ORA-01114 for a datafiles that does not exist.