"ORA-01114: IO error writing block to file" Captured In ODI Operator Session Log (Doc ID 1467138.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

Given an Oracle Data Integrator (ODI) specific Procedure that implements the following anonymous PL/SQL block:

begin
  execute immediate
    '
     create table <TABLE>
     tablespace <TABLESPACE>
     storage (
       initial 30m
       next 10m
       maxextents unlimited
       )
     NOLOGGING
     as
     select /*+index(a)*/ xyz
    ' ;
end ;

The execution of above Procedure fails, and the following error message could be observed in the ODI Operator Session log:

ODI-1228: Task <TASK> (Procedure) fails on the target ORACLE connection <CONNECTION> .
Caused By: java.sql.SQLException: ORA-01114: IO error writing block to file (block # )
ORA-06512: at line 2

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.