Re: SQL loader error

Hi

    If your problem still not solved with the proposals given already,     try changing '_' with '$'.
    Because we have our databases running with Informix & Oracle as back end servers.

    Our fields are translated with '_' in informix and '$' in Oracle. I can not tell you why we have this translation.

    But because of reserved letters '_' may not work in Oracle . I am not sure of this.

    try changing it to '$'

Wishes
Suresh

deepak_at_npac.syr.edu wrote:

> 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 Thu Aug 06 1998 - 03:23:09 CDT