-
Contributing Member
Sql loader
Hello,
Do we need to install sql loader seperately or does it install automatically while installing oracle 9i?
Regards
Babi
-
Expert Member
Re: Sql loader
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
-
Contributing Member
-
Expert Member
Re: 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
-
Contributing Member
Re: Sql loader
I created a CSV file from which data to be imported. Do I need to copy that file to bin folder?
-
Contributing Member
Re: Sql loader
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?
-
Expert Member
Re: Sql loader
u need to specify the path (i.e control=c:\example.ctl) or copy the file in bin
-
Contributing Member
Re: Sql loader
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?
-
Contributing Member
Re: Sql loader
fields terminated by "," optionally enclosed by '"' line also may not work?
Could anyone please post model control file for loading DBF data.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules