https://www.ptc.com/appserver/cs/view/solution.jsp?n=132834

Solution Details - TPI
Number 132834 
Type TPI 
Created Date 27-Apr-2006 
Last Updated 27-Apr-2006 
Title Error: "ORA-01652 Unable to extend temp segment by 128 in tablespace TEMP" occurs while running "ildataloader Link 2". 
Details Description 
Error: "ORA-01652 Unable to extend temp segment by 128 in tablespace TEMP" occurs while running "ildataloader Link 2".

Resolution 
Follow the example below to set autoextend on for TEMP tablespaces on both Pro/INTRALINK 3.x and PDMLink 8.0 (or Pro/INTRALINK 8.0):

Additional Information 
Follow the example below to set autoextend on for TEMP tablespaces on both Pro/INTRALINK 3.x and PDMLink 8.0 (or Pro/INTRALINK 8.0):

On PDMLink 8.0 database:

H:\>sqlplus system/manager@wind

SQL*Plus: Release 9.2.0.5.0 - Production on Thu Apr 27 08:30:43 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL> select file_name from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------

D:\PTC\PDMLINK\OCU\ORADATA\WIND\WINDTEMP.DBF

SQL> alter database tempfile 'D:\PTC\PDMLINK\OCU\ORADATA\WIND\WINDTEMP.DBF' autoextend on;

Database altered.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

H:\>

On Pro/INTRALINK 3.x database:

H:\>sqlplus system/manager@intralink

SQL*Plus: Release 9.2.0.5.0 - Production on Thu Apr 27 08:35:15 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL> select file_name from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------

D:\PTC\DATASERVER34\INTRALINK\DBS\ILNK_TEMP_01.DBF

SQL> alter database tempfile 'D:\PTC\DATASERVER34\INTRALINK\DBS\ILNK_TEMP_01.DBF' autoextend on;

Database altered.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

H:\>