Spooling data from clob

[Muskaan]

Hi all,

I am trying to spool data from a clob table as follows:

--------------------------
set long 10000
spool archive_data/N_DBA.TDETAIL.dat
select x from clob_table order by id;
spool off
-------------------------

where x is a CLOB.
in my file, the data is split into 80 byte lengths. So one row is split into several lines . Is there a way the output can be spooled without the extra new-line characters ?

 

[cliousa]

Check this article:

http://www.dbaclick.com/forums/archive/15/2549.html

(CREATE OR REPLACE PROCEDURE retrieve_lob ).

It shows how to retrieve LOB data to flat file.




Hope that helps,
clio_usa - OCP DBA
------------------

http://www.dbaclick.com

 

[sem]

80 characters limit is set by LINESIZE sql*plus parameter. You may increase it as you need

Regards, Dima

 

[Muskaan]

Thanks for your help cliousa! I am now successfully writing cob data into a file.
Dima, I suppose there is still an upper limit to the LINESIZE parameter, I cannot write all of the 2 Gig data through sql*plus. Thanks for your help!