Transform and Load failed with error "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" for Servigistics InService 6.4

[DEBUG,RegistryDAO]  SQL statment to getNonOrphanedNodesForGivenID : SELECT REGISTRYID FROM SC_REGISTRY where ORPHAN_PART_INDICATOR='1' and ( REGISTRYID IN (?, ?, ?, ?, ?))
[EBUG,RelationDAO] The messageId: [****In fetchGraph, fetching graph for:: 6351936001476825403] does not exist. The message uses the following tokens: 
[ERROR,ProcessActionHandler] Failed node: saveRegistryEntries within flow: registerManifestFile_PD , reason ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
org.xml.sax.SAXException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

[DEBUG,RegistryDAO]  SQL statment to getNonOrphanedNodesForGivenID : SELECT REGISTRYID FROM SC_REGISTRY where ORPHAN_PART_INDICATOR='1' and ( REGISTRYID IN (?, ?, ?, ?, ?))
[DEBUG,RelationDAO] The messageId: [****In fetchGraph, fetching graph for:: 6351936001476825403] does not exist. The message uses the following tokens: 
ERROR,ProcessActionHandler] Failed node: saveRegistryEntries within flow: registerManifestFile_PD , reason No more data to read from socket
org.xml.sax.SAXException: No more data to read from socket
java.sql.SQLRecoverableException: No more data to read from socket
        at com.ptc.sce.iman.RegistryCollection$RegistryInfoParser.endElement(RegistryCollection.java:596)
        at org.apache.xerces.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:598)

Caused by: java.sql.SQLRecoverableException: No more data to read from socket
        at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:453)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:390)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)