Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
SQL execution error - ORA-25153: Temporary Tablespace is Empty
설명
The below error could be received during reorg,
SQL execution error - ORA-25153: Temporary Tablespace is Empty
원인
It may be due to insufficient space or if there are other transactions running against it. This could also be related to the "temporary objects" still held in the Temporary tablespace from a previously aborted reorg job
해결 방안
You can either recreate the tempfile of the tablespace with additional space to flush the old objects or manually drop the left-over objects from the cancelled or failed reorg job
