You need to specify database connection string with the sqlldr command to identify the target database for load. Remaining information about the input data and format can be specified in the control parameter, as shown in the following code snippet:
sqlldr username/password@server control=sample.ctl
The preceding sample control file (sample.ctl) will load an external datafile containing delimited data, given as follows:
load data
infile 'c:\data\mydata.txt'
into table emp
fields terminated by "|" optionally enclosed by
( empno, empname, sal, deptno )
The mydata.txt file appears as follows:
110010| "Ram Singh" |70000|390
110002| "Shyam Kumar"|50000|570
sqlldr username/password@server control=sample.ctl
The preceding sample control file (sample.ctl) will load an external datafile containing delimited data, given as follows:
load data
infile 'c:\data\mydata.txt'
into table emp
fields terminated by "|" optionally enclosed by
( empno, empname, sal, deptno )
The mydata.txt file appears as follows:
110010| "Ram Singh" |70000|390
110002| "Shyam Kumar"|50000|570