Re: ORA-00913

If it always fails at row 54 then we need to see rows 53, 54, and 55. Look there and see if you have an extra delimiter or if somehow you got two records on the same line.

Best!

Randall

Rui Caetano <ehanover_at_tellurian.com> wrote in message news:AGdN6.15824$iC1.550584_at_news6.giganews.com...
> There are exactly 7 columns on the table and on the tab delimited file. It
> seems to stop at exactly 54 rows with that error message. I checked the
 size
> of the fields and the fields are big enough for any of the values being
> imported. The fields are:
>
> VendorNo Char 5
> VendorName Char 30
> Street Char 25
> Street1 Char 25
> City Char 20
> State Char 2
> Zip Char 5
>
> Here is a sample of the input file:
>
> 00001 DEBBIE SANTANGELO 3 ALEXIS COURT EAST HANOVER NJ 07936
>
> Thanks,
> Rui
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tg88thc1kuvc56_at_beta-news.demon.nl...
> >
> > "Rui Caetano" <ehanover_at_tellurian.com> wrote in message
> > news:%aVM6.14227$iC1.488379_at_news6.giganews.com...
> > > I'm trying to import a coma seperated file into a table using Oracle8
> > > Navigator but I keep getting this error:
> > >
> > > ORA-00913: too many values.
> > >
> > > Online help doesn't tell me much about the error or how to go about
 fixing
> > > it, what's wrong and how do I fix it?
> > >
> > > I'm a novice trying to learn so please be gentle if my question seems
 really
> > > stupid.
> > >
> > > TIA
> > > Rui
> > >
> > >
> >
> > The error means you have more values (expression, expression, expression
> > ....)
> > than you have columns in your table.
> > Without further details I can't be of further assistance.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> >
> >
>
>
Received on Wed May 23 2001 - 09:34:13 CDT