Is there an OCI/procedures that manipulate lob data?
If there is, I suggest you separate the lob column into
a separate table with the key of the original table. Then
create a big rollback segment, and use the
SET TRANSACTION USE ROLLBACK SEGMENT BIG_RBS
before the manipulation of data is called.