-
Title
Compare fails:ORA-01114: IO error writing block to file -
Description
compare fails:ORA-01114: IO error writing block to file
-
Cause
The device on which the Oracle 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. ***** This error can happen because due to a crated temporary data file in mount point that did not extend t completely and was unable to extend.
-
Resolution
1. Make sure that compare is not running.
2. Drop and recreate your temp tablespace. procedure: create a new temp tablespace, make this as the default temp tablespace and drop the old one (in 9i , drop tablespace temp including contents and data files).
3. Retry compare -
Additional Information
When creating a temp file, it doesn't immediately occupy the OS space unless, otherwise all the segments are extended.