My Oracle Support Banner

Sqlldr Not Loading All Data In DAT File : SQL*Loader-510 / SQL*Loader-2026 (Doc ID 741100.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Dec-2013***

Symptoms

The following symptoms are attributed to this issue :-

1) SQLLDR is being used to load a datafile whose contents are not considered to contain invalid records.

2) Not all records get loaded and in the logs we see messages similar to :-

SQL*Loader-510: Physical record in data file ([xx].[xx].[xx].dat) is longer than the maximum(1048576)
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Specify SKIP=xx when continuing the load.

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.