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
- Oracle
- 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.