Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Loader-500: error and SQL*Loader-555: unrecognized processing option

3725928Aug 10 2018 — edited Aug 10 2018

I am getting the following error when I run sql loader...can someone please help

SQL*Loader-500: Unable to open file (/u01/app/applmgr/OADEV1/shared/apps/apps_st/appl/nord/12.0.0/data/in_data/nord_ems_sae.dat)

SQL*Loader-555: unrecognized processing option

here is the part of the sql loader script that is causing error

options ( bindsize=2000000000, readsize=2000000000)

LOAD DATA

APPEND

I was getting error below previously so I added the  options clause to the control file  => options ( bindsize=2000000000, readsize=2000000000)

SQL*Loader-510: Physical record in data file (/u01/app/applmgr/OADEV1/shared/apps/apps_st/appl/nord/12.0.0/data/in_data/nord_ems_sae.dat) is longer than the maximum(1048576)

SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
This post has been answered by 3725928 on Aug 10 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2018
Added on Aug 10 2018
#database-key-features, #export-import-sql-loader-external-tables
8 comments
2,018 views