Re: How can I export table/view to a FIX Length OS File ?

I am exporting the table/view. it is too slow spooling.

Do you have a way to do it ?

Thanks

Raymond Du

Matt Brennan wrote in message <01bd8347$529a4300$049a0580_at_mcb>...
>Are you exporting the table or just spooling that table's data? If
>spooling, use the spool command, but before you do that, set echo, heading,
>verify, and feedback to 'OFF', set pagesize to '0', and set linesize to the
>proper width, and possibly set trimspool to 'ON'. In your SQL statement,
>use rpad or lpad to right-pad or left-pad the data with spaces to the
>correct length.
>--
>Matt Brennan
>SQL*Tools Specialist
>GERS Retail Systems
>9725-C Scranton Road
>San Diego, California 92121
>1-800-854-2263
>mbrennan_at_gers.com
>(Original email address is spam-blocked.)
>
>Raymond Du <rdu_at_idmcorp.com> wrote in article
><6jsdbh$jo0_at_nntp02.primenet.com>...
>> Solaris 2.6 / ORACLE 7.3.
>>
>> Thanks very much for help.
>>
>> Raymond Du
>> rdu_at_idmcorp.com
>>
>>
>>
Received on Tue May 19 1998 - 19:07:02 CDT