Re: ORA-00913

From: Rui Caetano <ehanover_at_tellurian.com>
Date: Mon, 21 May 2001 08:28:35 -0400
Message-ID: <dS7O6.19010$iC1.723381@news6.giganews.com>

Greg I also tried tab delimetered file and got the same message. Here are a few lines from my input file:

00001,DEBBIE SANTANGELO,3 ALEXIS COURT,,EAST HANOVER,NJ,07936
00002,CAROL GETSINGER,57 BARNIDA DRIVE,,EAST HANOVER,NJ,07936
00003,LORRAINE N. OREST,11 SAMUEL STREET,,EAST HANOVER,NJ,07936
00004,KAREN DE PALMA,63 GRANT AVENUE,,EAST HANOVER,NJ,07936
00005,RICHARD L. SMITH,18 SAMUEL STREET,,EAST HANOVER,NJ,07936

Thanks for your interest.

"Greg Teets" <gteets_at_rr.cinci.com> wrote in message news:3b066921.1068435579_at_news-server...
> Your original post said these are comma-delimited files. If so,
> please post a line with the commas.
>
> Is each record a separate line in the file?
>
> How about posting up about 5 lines from the file so I can look at
> them? Then I can help you in more detail.
>
> >> > I'm trying to import a coma seperated file into a table using Oracle8
> >> > Navigator but I keep getting this error:
> >> >
>
Received on Mon May 21 2001 - 07:28:35 CDT