My Oracle Support Banner

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

Last updated on APRIL 17, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.