The Oracle database uses temp space for doing sort operations and storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory, space will be allocated in a temporary tablespace for doing the sort operation. Other SQL operations that might require disk sorting are: CREATE INDEX, ANALYZE, Select DISTINCT, ORDER BY, GROUP BY, UNION, INTERSECT, MINUS, Sort-Merge joins, etc.
This issue is typically resolved by enabling the auto extend feature for the tablespace in question or by adding another data file to the tablespace in question.
If you encounter this error, please create a support request, providing the details of the issue and referencing this solution.
Connect and collaborate with fellow Blackbaud users.