Thread: Sql loader

Hello,

Do we need to install sql loader seperately or does it install automatically while installing oracle 9i?


Regards
Babi

sql loader is a bulk loader utility to moving data from external files to oracle database and is installed along with the oracle 9i software

How to start sql loader?

From command prompt run

sqlldr user/passwd control=example.ctl log=example.log data=example.dat

sqlldr is in bin folder in oracle 9i

I created a CSV file from which data to be imported. Do I need to copy that file to bin folder?

Typing the following command at sql prompt throughs error message.

Sqlldr username/password control = loader.ctl

Error :- Unable to open file loader.ctl

Is it must to create a new control file or else comes with default control file?

u need to specify the path (i.e control=c:\example.ctl) or copy the file in bin

The following control file is working fine for CSV files.

load data
infile 'd:\one.csv'
into table emp
fields terminated by "," optionally enclosed by '"'
( EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)


To load DBF file data
infile 'd:\one.dbf' modification is enough or do I need to do any other modifications in the above control file?

fields terminated by "," optionally enclosed by '"' line also may not work?

Could anyone please post model control file for loading DBF data.