Sql*Loader-700: Out Of Memory While Performing Essential Allocations [7]

(Doc ID 833931.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4
This problem can occur on any platform.

Symptoms

Encountering the error "SQL*Loader-700: Out of memory while performing essential allocations [7]"
on a new 10g installation.

Not using direct path. Tried lowering the columnarraryrows value to 10 and still get the error.

The control file is large at 8000 lines long. However there are no such problems when using
this against an 8i instance.


Cause

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 hundreds of Community platforms