Hi

what are you attempting at could you show me the steps.you cannot directly convert a long data type to blob or clob .you will have to spoll the data to a text file and create a table with a blob or clob data type nad then load this table using sqldr.

kindly refer to this thread for more details
http://www.dbasupport.com/forums/sho...?threadid=8170

regards
hrishy