We have some tables with CLOB columns. During our performance testing, we inserted a large number of rows into these tables. Eventually, our application started erroring out with the message from Oracle:
With some analysis, we found that the temporary space was being filled and never released, until we shutdown our application.ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
This problem occurs only in Direct Mode. We tested with the Oracle Client and we didn't run into this problem.
In the change history (http://www.devart.com/History.aspx?prod ... ect/oracle), I found this entry for 6.00.69 16-Dec-10:
Could it be that this bug was fixed for the Oracle Client but not for Direct Mode? When will this bug be fixed?Fixed bug with freeing temporary tablespace when creating multiple LOBs
We tested with Devart dotConnect for Oracle v18.104.22.168.