Red Hat Satellite fails to generate channel repodata, with "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS" error in Taskomatic logs

Issue

• repomd.xml update extremly slow after install of Satellite server
• in the Taskomatic logs we see :

INFO   | jvm 1    | 2012/11/07 11:23:37 | 2012-11-07 11:23:37,185 [Thread-58] INFO  com.redhat.rhn.taskomatic.task.repomd.RepositoryWriter - Generating new repository metadata for channel 'rhn-tools-rhel-x86_64-server-6'(sha256) 82 packages, 19 errata
INFO   | jvm 1    | 2012/11/07 11:23:54 | 2012-11-07 11:23:54,311 [Thread-59] ERROR com.redhat.rhn.taskomatic.task.repomd.PackageCapabilityIterator - SQLexception
INFO   | jvm 1    | 2012/11/07 11:23:54 | java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS
INFO   | jvm 1    | 2012/11/07 11:23:54 |
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at com.redhat.rhn.taskomatic.task.repomd.PackageCapabilityIterator.<init>(PackageCapabilityIterator.java:78)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at com.redhat.rhn.taskomatic.task.repomd.PrimaryXmlWriter.begin(PrimaryXmlWriter.java:92)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at com.redhat.rhn.taskomatic.task.repomd.RpmRepositoryWriter.writeRepomdFiles(RpmRepositoryWriter.java:166)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at com.redhat.rhn.taskomatic.task.repomd.ChannelRepodataWorker.run(ChannelRepodataWorker.java:104)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
INFO   | jvm 1    | 2012/11/07 11:23:54 |       at java.lang.Thread.run(Thread.java:738)