Why is Bad File Created in Wrong Directory When Running Concurrent Program That Uses SqlLoader (Doc ID 1327246.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

Running a concurrent program and try to upload a flat file to Oracle using SQL*Loader through a parameter file, references a bad file. Ideally for any SQL*Loader program the bad records should be written into the bad file.

Rather than the bad file been generated in the specified temporary location it is been generated in the regular $APPLCSF/$APPLLOG, why is this happening?


Solution

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