Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00913

Re: ORA-00913

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 17 May 2001 21:19:09 +0200
Message-ID: <tg88thc1kuvc56@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 Thu May 17 2001 - 14:19:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US