使用oracle Developer 工具运行pl/sql 代码时出现ORA-01652:unable to extend temp segment by 128 in tablespace TEMP 是什么错误，如何解决！！！

[ 本帖最后由 僵尸道长 于 2008-6-23 18:14 编辑 ]

Download and apply patch 4540431 PAYMENT SUMMARY DATA FILE PROCESS FAILS WITH
HR_6881_HRPROC_ORA_ERR.

不愿意打補丁，就看看這個：
Applies to:
Oracle General Ledger - Version: 11.5.10
This problem can occur on any platform.
Symptoms
GLSTPM module: Add/Delete Summary Accounts request
ends with
SHRD0043: ERROR: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Cause

CBO (Cost Based Optimization) was used instead of RBO (Rule Based Optimization)
Solution

Set the Profile Option:

"GL Journals: Use Alternative Optimization Method For Summarization" to Yes

This will bring the system to use RBO instead of CBO.

很明显的tablespace满了嘛。去加吧。

楼主可有解决问题？