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
