Re: need help with txt to oracle import

[Quoted] i use sqlldr witht he following in the loader.ctl file

        load data
          infile 'D:\college\assignments\359\359database\klse.txt'
          fields terminated by ","
          into table indexs (indate, indexs, volume)

and it gives me the error:

SQL*Loader-350: Syntax error at line 3.
Expecting keyword INFILE, keyword INTO or end of file, found keyword fields.

          fields terminated by ","
   ^

what is wrong with my code ?

"user" <utagi_at_yahoo.com> wrote in message news:3dfabcf1_2_at_news.tm.net.my...
> create table Indexs
> ( indate date not null constraint Index_Date_PK primary key,
> indexs number(8,2) not null,
> volume number(8,2) not null);
>
> alter session set NLS_DATE_FORMAT='<DD-MM-YY>';
>
> THESE ARE THE commands that i run before i import ... the text file
context
> is like below:
>
> 29-06-00,830.2500, 237.0000
> 30-06-00,833.3700, 160.0000
> 03-07-00,793.9300, 104.0000
> 04-07-00,807.8700, 89.0000
> 05-07-00,818.6900, 95.0000
> 06-07-00,815.6800, 95.0000
> 07-07-00,820.4700, 135.0000
> 10-07-00,837.5900, 206.0000
>
> can anyone tell me how should i import them to my oracle ?
> i've tried sqlldr , but it seems that my oracle does have it, it says
> "SP2-0042: unknown command "sqlldr" - rest of line ignored."
>
> using oracle8i (8.1.7) personal edition on winxp
>
> thanks
>
>
Received on Sat Dec 14 2002 - 07:29:31 CET