Re: need help with txt to oracle import

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

1. 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 Sun Dec 22 2002 - 15:40:38 CET