Database Utilities (MOSC)

MOSC Banner

Sqlldr and Control file

edited May 31, 2013 6:00AM in Database Utilities (MOSC) 4 commentsAnswered
Hi,

I am trying to pass the data file name as a concurrent program parameter to a shell program and I am passing this file to sqlldr command line argument

as

sqlldr $FCP_LOGIN  control=$XXASC_TOP/bin/${control_file} data=$SOURCE_PATH$FILE_NAME1 log=$SOURCE_PATH$LOG_FILE$timestamp.log errors=0

The control file is :

OPTIONS (SKIP=1)
LOAD DATA
INFILE *
BADFILE '/u01/oracle/AMALTEST/apps/apps_st/appl/xxasc/12.0.0/inbound/ar/Customer.bad'
BADFILE '/u01/oracle/AMALTEST/apps/apps_st/appl/xxasc/12.0.0/inbound/ar/Customer.dis'
APPEND
INTO TABLE "AR"."RA_CUSTOMERS_INTERFACE_ALL"
FIELDS TERMINATED BY ','

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center