My Oracle Support Banner

"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:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


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

  execute immediate
     create table <TABLE>
     tablespace <TABLESPACE>
     storage (
       initial 30m
       next 10m
       maxextents unlimited
     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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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