29.9 Troubleshooting the ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

The ORA-01652: unable to extend temp segment by 128 in tablespace TEMP error appears, when the temp tablespace have default size and the current transaction involves more number of records with clob data type.

To troubleshoot this scenario, perform either of the following or both:

  1. Add extra dbf file for temp tablespace.

  2. Reduce the number of records for the transaction (For Database Migration if you are using default batch size 10,000 that can be reduced to 100 or 500 or 1000 based on the nature of each record having clob data.).

IMPORTANT:For better performance depending on the database size and resource availability, you can increase the batchsize in the db-migration-mssql-to-oracle.properties file. It is located in %ZENWORKS_HOME%\novell\zenworks\conf\ on Windows and in /etc/opt/novell/zenworks/conf/ on Linux.