Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem while inserting data using sqlldr utility.
Shravana Kumar <kumar.shravana_at_blr.spcnl.co.in> wrote in message news:<3E0B56F7.A1D24710_at_blr.spcnl.co.in>...
> Hi All,
>
> I am trying to insert bulk of data into a table using SQL*Loader
> utility. But the data is not properly getting inserted. Any ideas are
> helpful ..!
>
> We are using oracle 9.2.0 on solaris 8 and i follow this way.
>
> sqlldr scott/tiger control=loader.ctl
>
> The loader.ctl file contains the following lines.
>
> load data
> infile 'c:\data\mydata.csv'
> fields terminated by "," optionally enclosed by '"'
> into table emp ( empno, empname, sal, deptno )
>
> The mydata.csv file may look like this:
>
> 10001,"Scott Tiger", 1000, 40
> 10002,"Frank Naude", 500, 20
>
> The result looks like this.
>
> SQL> select * from emp;
>
> EMPNO EMPNAME SAL DEPTNO
> ---------- -------------------- ---------- ----------
> 1 0 0
> 0
> 1 0 0
> 0
>
>
>
> Best Regards,
> ShravanaKumar.
Change statement,
> fields terminated by ","
to,
fields terminated by ','
then try again.
Regards
/Rauf Sarwar
Received on Fri Dec 27 2002 - 13:48:22 CST