SQL loader error

From: <deepak_at_npac.syr.edu>
Date: Tue, 04 Aug 1998 21:03:15 GMT
Message-ID: <6q7suj$vs2$1@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

-----== 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 - 16:03:15 CDT