SQL*Loader-522: lfiopn failed for file (//DD:<DD-name>) and SQL*Loader-509: System error: lrecl too small, following upgrade to 10gR2
Last updated on APRIL 24, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.5 [Release 10.2]
IBM z/OS on System z
10.2.0.3/10.2.0.5 SQL*Loader fails with the following errors:
SQL*Loader-554: error opening file
SQL*Loader-509: System error: (NO DATA)
SQL*Loader-509: System error: lrecl too small
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
The DD name referred to in message SQL*Loader-522 is the DD name used for either the BAD or DISCARD dataset.
An upgrade from 9.2 to 10gR2 has taken place
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