Re: ORA-00913

From: Rui Caetano <ehanover_at_tellurian.com>
Date: Fri, 18 May 2001 14:16:38 -0400
Message-ID: <AGdN6.15824$iC1.550584@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 Fri May 18 2001 - 13:16:38 CDT