Hello, in the past I’ve been able to use the query below to export file attachments stored in a Clob field. I would right click on the ls_value field, select Export Blobs (Longs, Raw) and would export to the destination I would select. Now Toad exports between 2,000 - 3,000 attachments and stops or exports blank files. I need to export over 700,000 attachments. Does anyone have any suggestions?
select ls_value, ‘(’ || pad.pr_id || ') ’ || substr(s_value, instr(s_value, ‘’, -1, 1)+1, length(s_value) - instr(s_value, ‘’, -1, 1)) nme
from pr_addtl_data pad, data_fields df
where PAD.DATA_FIELD_ID = df.id
and df.name = ‘File Attachment(s)’
and PAD.PR_ID < 500010