This error occurs before the switch when creating indexes on other tables.
Below is an excerpt from the script execution log before the error:
2] 10/02 14:43:27 line=30 sql=Create UNIQUE Index FAB300.QUEST_SPC_TMP_55189_LRIDX on FAB300.QUEST_SPC_TMP_55188_LRTAB (
TRANSACTION_ID, COMPONENT_ID, METHOD_NAME)
Tablespace F3_HST_INDX_N
PctFree 10
IniTrans 2
MaxTrans 255
Logging
NoParallel
Storage (
Initial 64K
Freelists 1
Freelist Groups 1
Buffer_Pool Default)
[2] 10/02 16:00:58 ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
[2] 10/02 16:00:58 AbortScriptWithError()
[2] 10/02 16:00:58 AbortScript: Aborted ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
(os errno 25)
Tablespace is out of space.
Set the Temp tablespace autoextensible with an appropriate maximum size from the Tablespace Explorer. You can right-click on 'temp' | properties. On the 'autoextend' column, set it to 'on' .
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center