Re: Can anyone explaining what's happening !!!

From: <eswar_oracle_at_hotmail.com>
Date: Wed, 24 Feb 1999 02:30:27 GMT
Message-ID: <7avo84$iid$1@nnrp1.dejanews.com>

Hi Roy

Thanks for your suggestion. It is working with Integer Extenal. My problem is solved.

But similar data I had been loading into Diff table using Number in control file instead Integer External. But wonder how it is working.

Any way thanks for your help

Eswar

In article <7au2b9$cvh$1_at_readme.online.no>, "Roy Brokvam" <roy.brokvam_at_conax.com> wrote:
> Hi!
>
> eswar_oracle_at_hotmail.com wrote in message
> <7atvj7$23$1_at_nnrp1.dejanews.com>...
> >
> >
>
> [snip]
>
> >
> >This is my control file
> >
> >load data
> >infile 'PRODUCT1.TXT'
> >Append
> >into table PRODMAST_TEST
> >(PRODCODE position (01:05)NUMBER
> >PRODDESC position (06:25)char,
> >LABCODE position (26:29)CHAR,
> >LAUNCHMY position (30:35)NUMBER,
> >UPDPERIOD position (36:39)char,
> >GENERIC_FLAG position (40:40)char,
> >DELFLAG position (41:41)char,
> >)
> >
>
> It's been a while since i did any SQL*Loader work, but I am quite certain
> that you should use "integer external" instead of "number" in the control
> file.
>
> HTH,
>
> Roy Brokvam
> roy.brokvam_at_conax.com
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 23 1999 - 20:30:27 CST