Oracle Unable to extend temp segment by Tablespace temp

Description

Error Report:
SQL Error:ora-12801:error signaled in parallel query server P010
Ora-01652:unable to extend temp segment by Tablespace temp
12801.00000-"error signaled in parallel query server%s"
*cause:a Parallel Query server reached an exception condition.
*action:check the following error message for the cause, and consult
Your error manual for the appropriate action.
*comment:this error can turned off with event 10397, in which
Case the server's actual error is signaled instead.

Caused by

There is not enough temporary table space. There may be too many subqueries, or the intermediate result is too large.

Solution

1. Increase temporal table space
2. Optimize SQL (Create Index, remove order, etc. to reduce the use of temporary tablespace)

References

• Ora-01652:unable to extend temp segment by tablespace system:how to extend?

Oracle Unable to extend temp segment by Tablespace temp