Re: Urgent: Data Migration Question?

In the server utilities manual, the documentation for SQL*Loader (Chapter 5 for Oradle7) has all of the goodies. The parameter that you are looking for is "CONCATENATE n" (in your case "CONCATENATE 3") and this should solve your problem.

HTH
    James

In article <7gu4gt$k77$1_at_nnrp1.deja.com>,   vishu2_at_hotmail.com wrote:
> Greetings,
>
> I have a huge text file that needs to be loaded into Oracle database table
> and the format of the data in the file is as follows:
>
> LNAME1 % FNAME1 % MNAME1 % DOB % ADDRESS %^
> CITY % STATE % ZIP % PHONE_NO % SSN %^
> COMMENTS %^
> LNAME2 % FNAME2 % MNAME2 % DOB % ADDRESS %^
> CITY % STATE % ZIP % PHONE_NO % SSN %^
> COMMENTS %^
> and so on ....
>
> The layout of the source file is such that it is not wrapped but a carraige
> return represented by "^" in the above example, even though it is the same
> record. Thus one single record is spread for three lines and I am having
> trouble parsing it to make look as a single record using SQL*Loader to do
> the upload.
>
> How to do the upload and map the huge amount of data. How can I concatanate
> the three lines into one single record?
>
> Any help would be greatly appreciated.
>
> Thanks in advance
> Vishwa
> vishu2_at_hotmail.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 08:43:31 CDT