Zurück
-
Titel
Live reorg fails with Oracle error "ORA-01652: unable to extend temp segment by 1093500 in tables -
Beschreibung
Live reorg fails with Oracle error ORA-1652...
The reorg log shows;
[2928] 04/04 15:45:31 ORA-01652: unable to extend temp segment by 1093500 in tablespace PSAPTEMP
[2928] 04/04 15:45:31 AbortScriptWithError()
[2928] 04/04 15:45:31 AbortScript: Aborted ORA-01652: unable to extend temp segment by 1093500 in tablespace PSAPTEMP -
Ursache
During the reorg the named tablespace has run out of space.
-
Lösung
Increase the free space in the tablespace and resume the job.
If more space is not available, the job will need to be cleaned up.