Solve the Oracle CLOB field data too big problem

1 Select *  fromUser_lobswheretable_name='Wx_mail';--sys_lob0001313121c00015$$2 SELECTSegment_name asTablename,bytes/1024x768/1024x768MB fromUser_segmentsWHERESegment_name='sys_lob0001313121c00015$$';

Wx_mail has a Content field Clob type that holds the contents of the message, causing the data to be too large, with an average content size of 40K. More than 180 w data, data accounted for 60G capacity,

The above SQL is the capacity of the query. To this end, the solution is to save only the failed message content, in order to fail the resend convenience, success will no longer save the sent content.

Solve the Oracle CLOB field data too big problem