Yes, use DBMS_LOB and UTL_FILE. UTL_FILE has a 32k line length limit, so you will be required to output to multiple lines for CLOB's > 32k.
If you don't have any restrictions on how this is done, use Perl, Java or C instead, and avoid the UTL_FILE limitations. Jared On Tuesday 12 November 2002 15:58, Sergei wrote: > Hello everyone, > > I am trying to offload data from multiple tables into one text file. > The problem is couple of the fields are clobs. Any advices how to deal > with clobs? > > Sergei -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
