Re: need help with txt to oracle import

sqlldr is an OS command. I think the problem is you run it in SQL. "Richard Xu"< richardxu_at_yahoo.com >

"André Gamache" <andre.gamache_at_ift.ulaval.ca> wrote in message news:3E05CEE6.5070404_at_ift.ulaval.ca...
> Hi:
> If you don't have more data just run an Insert DML for each line of
> data. If you have much more data, run sqlldr ou sqlldr80 from the OS
> prompt level not within SQL*Plus. or see the DBA.
>
> Good luck
>
> A. Gamache
>
> user wrote:
> > 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 28 2002 - 02:00:48 CET