Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.