This discussion is archived
4 Replies Latest reply: Jan 11, 2013 3:13 AM by Muthu RSS

Sql loader control file path........

Muthu Newbie
Currently Being Moderated
Hello all,

I am running the below query through sql loader from client machine.....

saved the below query in loader.ctl file, which I kept in "D:\loader.ctl" path....

options (skip=1)
load data
infile 'D:\flat.txt'
into table GL_INTERFACE
fields terminated by "," optionally enclosed by '"'
*( STATUS, LEDGER_ID, USER_JE_SOURCE_NAME, USER_JE_CATEGORY_NAME, ACCOUNTING_DATE, CURRENCY_CODE, DATE_CREATED, CREATED_BY,*
SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACTUAL_FLAG, ENTERED_DR, ENTERED_CR, GROUP_ID )

Now my doubt is, to execute the above I have to run the below command in sql loader....

sqlldr USERID=apps/apps CONTROL=loader.ctl

In the control file we have given the path for the data file, but * How the command (SQLLDR) identify the path of control file.?*

Do I need to give or......?

Is it possible to run the above loader program in client machine? or we have to run only server alone.....

Please clarify my doubt.

Thanks and Regards,
Muthu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points