We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

gtorres8
Alteryx
Alteryx
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.