Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gizzel123
Creator
Creator

Unable to extend temp segment by 128 in tablespace TEMP

Hi All,

I am creating a QVD with the SQL Script. Previously it  was loading fine, but now it has started failing throwing this error:

unable to extend temp segment by 128 in tablespace TEMP.


Please advise.


Thanks.

3 Replies
petter
Partner - Champion III
Partner - Champion III

You should contact the DBA of the SQL database as the SQL query seems to have a problem executing due to not enough temporary space for some reason. This might be because of sorting, indexing, joins which we could only guess at since we don't see your SQL query. But your DBA should be able to analyze the query and change either the query, extend the tablespace TEMP or create the right indexes so it will execute successfully again.

Gysbert_Wassenaar

That is an oracle error that has nothing to do with your qvd or qlikview. Contact your local friendly oracle database administrator. He/she can increase the size of the TEMP tablespace, but perhaps can also help you create a more efficient query to retrieve the data you need.


talk is cheap, supply exceeds demand