Hello,
Do we need to install sql loader seperately or does it install automatically while installing oracle 9i?
Regards
Babi
Printable View
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.