"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 10.1.3.5.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |