My Oracle Support Banner

'ODI-40761: Not enough memory to read the XML file' Signaled when Loading a Very Large XML File with the ODI 11.1.1.7 XML Driver External Database Feature (Doc ID 1552820.1)

Last updated on SEPTEMBER 13, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When attempting to load a very large XML file with the Oracle Data Integrator (ODI) version 11.1.1.7.0 XML driver using the external database feature with the following URL:

which seems to indicates that the loading of the XML is in memory and not in the external database.

Moreover, when attempting to use the other two methods to specify the data base properties:

  1. With a parameter file
  2. Adding parameters to the URL

for the external database feature, no problem is encountered.

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!

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