ERROR

ORA-01114: IO error writing block to file

Last Published: April 25, 2020

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

Article ID:000002227

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic