SQL*Loader-510: Physical record in data file (EBS_VENDOR_Sites.csv) is longer than the maximum(1048576)

This document describes how to resolve buffer issue when we load data with sql loader.

Error:

bash-4.1$ sqlldr apps/xxxxx control=XXTESTFILELOAD.ctl

SQL*Loader: Release 10.1.0.5.0 - Production on Tue May 23 12:36:01 2020
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL*Loader-510: Physical record in data file (EBS_VENDOR_Sites.csv)
is longer than the maximum(1048576)
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
bash-4.1$


Solution:

sqlldr is unable to read the total file due to less buffer. Execute sqlldr command with some high buffer value to read the document.

bash-4.1$ sqlldr apps/xxxxx  control=XXTESTFILELOAD.ctl  readsize=2500000

SQL*Loader: Release 10.1.0.5.0 - Production on Tue May 23 12:41:26 2020

- - - - - - - - - - -- -- - - - - - -

- - - - - - - - - - - - - - - - - - -

- - - - - - - - - - - - - - - - - - -



Thanks for going to through this post....