Re: Loading Long fields using SQLOADER help
Date: 18 Apr 1994 12:43 -0500
Message-ID: <18APR199412431620_at_author.gsfc.nasa.gov>
In article <2okerv$84g_at_tamsun.tamu.edu>, m0v5533_at_tamsun.tamu.edu (Mahesh Vallampati) writes...
>
>Yo Oracle Gurus,
>I need to load a long datatype from a file. can anyone mail me sample
>sqlloader-scripts scripts which u would have stashed away?I would like to have
>samples of free-format and fixed format loading scripts.
>Ur help would be appreciated.The long field is stored in a file as many
>physical records and i need to concatenate them i guess. I am missing some
>key-words which i am not able to put together.A sample script would be great.
>
>Thanks and Regards
>Mahesh Vallampati
>M.S. In EE
>Dept.of Electrical Engineering,
>Texas A & M University.
>Ph:(409)845-6189
>\\ In the Beginning there was Codd.....
If I recall correctly, SQL*LOADER has a problem with LONGs and you need to use Pro*Whatever. If you have Pro*C, I'll send you a load and unload program.
If I'm wrong and you can load longs with SQL*LOADER, could someone please disabuse me?
Jeff Chamblee Received on Mon Apr 18 1994 - 19:43:13 CEST