Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Error: "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP" in workflow connected to Oracle

gtorres8
Alteryx Alumni (Retired)
Created

Environment Details


When running a workflow the following error occurs:

 

DataWrapOCI: Unable to prepare the query: "SELECT ... (rest of the query)"
Error: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP

 

 

  • Alteryx Designer
    • All versions
  • Oracle
    • All versions
  • Oracle OCI


Cause


The tablespace called TEMP is running out of space (segments) to run the query results.



Resolution


Consult the Oracle DBA responsible for the Oracle database to alter the tablespace to extend the space.

 

Here is an example of the same issue and the alter command to create a new data file.