Environment
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server
RedHat Linux
Solaris 9
Sentinel 5.1.x
Situation
Error ORA-01652: unable to extend temp
java.io.IOException: ORA-01652: unable to extend temp segment
by 128 in tablespace TEMP
DAS_Query_0.0.log reporting error
Caused by: java.io.IOException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:717)
at oracle.jdbc.driver.OracleClobWriter.flushBuffer(OracleClobWriter.java:270)
at oracle.jdbc.driver.OracleClobWriter.flush(OracleClobWriter.java:204)
at esecurity.base.db.platform.OraclePlatform.setClobToPS(OraclePlatform.java:218)
... 22 more
||||esecurity.base.ccs.comp.BaseRemoteObjectTask|execute|
Caused by: java.io.IOException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:717)
at oracle.jdbc.driver.OracleClobWriter.flushBuffer(OracleClobWriter.java:270)
at oracle.jdbc.driver.OracleClobWriter.flush(OracleClobWriter.java:204)
at esecurity.base.db.platform.OraclePlatform.setClobToPS(OraclePlatform.java:218)
... 22 more
||||esecurity.base.ccs.comp.BaseRemoteObjectTask|execute|
Resolution
To resolve this, perform the following task.
Using sqlplus
alter tablespace temp add tempfile '/u02/oradata/temp_2.dbf' size 4000M
"/u02/oradata/" is where data location has been set to.
Using sqlplus
alter tablespace temp add tempfile '/u02/oradata/temp_2.dbf' size 4000M
"/u02/oradata/" is where data location has been set to.