Re: Newbie SQL*Loader question...

Hi Suresh;

    Actually your suggestion was the first thing that I tried. Apparently according to the message that I got, the SQL*Loader utility assumes that all fields are CHAR unless otherwise specified. Here are the messages that I got in the log when I just retried this:

Table TARGET_DEPT_HOURS_WCHARGE, loaded from every logical record. Insert option in effect for this table: APPEND

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ----
---------------------
EXP_1                               FIRST     *  WHT O(") CHARACTER
DEPT_CODE                            NEXT     *  WHT O(") CHARACTER
CHGDEPT                              NEXT     *  WHT O(") CHARACTER
EXP_4                                NEXT     *  WHT O(") CHARACTER

Record 1: Rejected - Error on table TARGET_DEPT_HOURS_WCHARGE, column EXP_4. ORA-01722: invalid number

Thanks for the idea, but it appears that I need to specify something to get it as a number. Or is there some command that changes the default loading assumptions?. Hmmmmm

Kathy

T.Suresh Kumar wrote:

> Hi
> In control file do not specify DECIMAL (9,4) .
> remove this and give in your control file as
> (exp_1, dept_code, chgdept, exp_4 )
> Now your data will be loaded properly.
> Do not specify data types except for DATE fields.
> I think it helps you.
>
> Wishes
> Suresh
>
> Kathy Graham wrote:
>
Received on Fri Jul 31 1998 - 01:05:58 CEST