English

Error: ORA-01114: IO error writing block to file

Error Message

These errors occur when attempting to use Oracle data files; similar errors are displayed in SQLplus when attempting to manually build a simple index on a table:

SDE Error(-51) Underlying DBMS error
Extended error code (1114): ORA-01114: IO error writing block to file 3
(block # 263)
ORA-274041: unable to open file
SVR4 Error: 13: permission denied
Additional information: 3
ORA-01114: IO error writing block to file 3 (block # 263)
ORA-274041: unable to open file
SVR4 Error: 13: permission denied
Additional information: 3
(GIS.F2_PK)
Not able to set layer into Normal-IO mode.
Cov2SDE completed

Cause

You don't have execute permission (UNIX file system) on the directory containing the Oracle data files, whose tablespaces the you are trying to use.

Solution or Workaround

Use the UNIX chmod command to give all users execute permission to the directory containing the Oracle data files:

Code:
%unix> chmod o+x data_directory