sqlerrm ORA-22297: warning: Open LOBs exist at transaction commit time

 Hi,

We have an Object Type which contains VARRAY of VARCHAR2. We are reading data from a flat file and collecting the same into Object ( VARRAY of VARCHAR2).

We have half a million data to be inserted into Object and from object it goes into staging table. Since our data volume is very high, program takes long time to load the data and sometime it is erroring out with error

sqlerrm ORA-01555: snapshot too old: rollback segment number 70 with name "_SYSSMU70$" too small To overcome above error, we are looking at releasing the rollback segment space by putting commit at every 50,000 records. While we do this, we get following error. sqlerrm ORA-22297: warning: Open LOBs exist at transaction commit time We can not close the LOB before processing all the data. At the same time, we have to release the space in rollback segment to avoid ORA-01555 error and improve the performance. DBA can neither increase the rollback segment space nor undo retention plan as this issue is not happening frequently. If any