EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB38820: ORA-01652: unable to extend temp segment by 128 in tablespace [TABLESPACE_NAME] when configuring the MicroStrategy Intelligence Server.

Community Admin

• Strategy

SYMPTOM
When configuring the Intelligence Server against an Oracle database, the following error is seen:
 

ka0PW0000002po1YAA_0EM4400000029rv.png

 
Error message


Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. 
ORA-01652: unable to extend temp segment by 128 in tablespace

 
 
CAUSE
A possible cause is that  the User ID being used to query the database is assigned to temporary tablespace that is not large enough.
 
ACTION
For a resolution, there are two options available and these need to be handled by the database administrator:
 
1. Increase the size of the temporary tablespace which can be used to query the database.
2. Switch the User ID being used to query the database to a user that has a larger temporary tablespace. 
 
 
 

Comment

0 comments

Details

Knowledge Article

Published:

June 1, 2017

Last Updated:

July 26, 2024