Re: need help with txt to oracle import

"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

pardon me for chiming in on 9i but in 9i you can use external tables and not have to worry about sql*loader. Perhaps you might want to inveestigate that as well Received on Mon Dec 30 2002 - 05:41:53 CET