Re: How to unload Oracle in ASCII flat fil

In article mpu_at_reeve.research.aa.wl.com, ditommm_at_aa.wl.com writes:
>
>> Hi everybody.
>>
>> I am new to this group so excuse me if you already discussed this issue.
>>
>> Our project needs to Unload a good amount of data from Oracle database.
>> The data should be in a classic flat file format with fixed length ASCII
>> records.
>> Do you know any good tool(s) to do it. I tried select * with various options,
>> but it is very slow. And apparently Oracle does not provide tools for it.
>> Their Export/Import facility creates a flat file in a very special format
>> which cannot be readable by a non-Oracle application.
>>
>> Thanks.
>> Vladimir.
>

Depending on the platforms you are working on you could also use oraperl, a perl derivative. The examples provided with oraperl provide the functionality you're looking for.

Regards,
David TvE

---
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen                      Business Systems Analyst
Motorola ASIC Division                            I don't speak for Mot.
Chandler, AZ-85224                                   fax: (602) 814-4451
email: ttg242_at_email.sps.mot.com                      tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-