Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

message: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP at OCI call OCIStmtFetch

2850269Feb 12 2015 — edited Feb 13 2015

Hi All,

we are getting this error for some of the reports. We already increased our temp table space in database. Even after increasing the table space we are getting the same error. Also, changed the process form 150 to 500.But the issue is still same.And for these reports we are using views and have the filter conditions too.

Any other alternative solutions to overcome this issue.

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 1652, message: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2015
Added on Feb 12 2015
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
1,469 views