Escape from boredom

We are in the process of migrating our IBM Filenet 5.1 environment to 5.2. During migration of the process engine, while running the script rmove.bat the script failed while migrating the table with most data. The error was:
Creating Table PE_DB.VWLOG3_911
Exception occurred while executing SQL statement.
Exception = java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

We did not entierly believe that this was the root cause, but more suspected a timeout. After some investigation, one of our developers took a closer look into the .jar file used (regmove.jar). There he found out the following

The utility tries to create a temp table as a copy of all rows in the log. That probably fails due to out of space for extending the segments.
Then it tries to drop the temp table and fails here.

static final int DB_ORACLE = 4;

     if (srcDb.type == 4)
      {
        SQLHelper.execSQLStmt(srcDb.connection, "create table " + tmpTbl + " as " + "(select * from " + srcDb.schema + "." + sourceTableName + ")");

        srcRs = srcStmt.executeQuery("select * from " + tmpTbl);
      }
      else
      {
        srcRs = srcStmt.executeQuery("select * from " + srcDb.schema + "." + sourceTableName);
      }

      copyRows(srcDb, destDb, table, sourceTableName, destinationTableName, srcRs, batchSize);

      JDBCHelper.closeDBObject(srcStmt);
      JDBCHelper.closeDBObject(srcRs);
      JDBCHelper.closeDBObject(destStmt);
      if (srcDb.type == 4)
      {
        SQLHelper.dropTable(srcDb, tmpTbl);
      }

… This was also confirmed by the DBA. So he then increased the available space for the schema. We then had to drop all tables in the new schema and rerun the script, now with success. Or actually, it did fail yet another time, but this time the developers of the script had managed to provide the correct error message

*** Creating indices in destination region
Exception occurred while executing SQL statement.
Exception = java.sql.SQLException: ORA-01652: unable to extend temp segment by 1
28 in tablespace PE_DB_TS