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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL loader error

Re: SQL loader error

From: Matt Brennan <mbrennan_at_gers.antispam.com>
Date: Tue, 04 Aug 1998 22:23:57 GMT
Message-ID: <01bdbff6$99321c20$049a0580@mcb>


> ACCESSCOUNT.HOUR_9.
Didn't you say it was hour_01, hour_02, hour_03...hour_09?

If so, you are missing the '0' in '09' in your control file? --
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

deepak_at_npac.syr.edu wrote in article <6q7suj$vs2$1_at_nnrp1.dejanews.com>...
> Hello all,
> I am attempting to create a table in Oracle 8.0 having the
> following column name:
> Hour_00,
> Hour_01,
> ...
> Hour09,
> Hour10,
> I have to load the tables with a datafile containing numbers.
> When I attempt to use Oracle loader I get the following error
> in the loader log file
>
> SQL*Loader-930: Error parsing insert statement for column
> ACCESSCOUNT.HOUR_9.
> ORA-00904: invalid column name
>
> The error message does not arise when I rename the column
> name as Hour_1, Hour_2 so on .
> Also it seems to stumble on the ninth table?
> I am creating the same table in Illustra and it works like a charm!!
> Any ideas??
> Thanks in advance,
>
>
> Deepak Ramanathan
> Webmaster Northeast Parallel Architectures Center
> Syracuse University,
> http://www.npac.syr.edu/users/deepak&#137;
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Tue Aug 04 1998 - 17:23:57 CDT

Original text of this message

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