. I recently encountered issue ORA-01652 unable to extend temp segment by 128 in tablespace DEV_IAS_TEMP while upgrade of application which is self explanatory. If you hit above error then check v$sort_segment _______ SQL> SELECT TABLESPACE_NAME,TOTAL_BLOCKS,USED_BLOCKS,FREE_BLOCKS FROM V$SORT_SEGMENT; Output in my case TABLESPACE_NAME TOTAL_BLOCKS USED_BLOCKS FREE_BLOCKS ——————————- ———— ———– ———– TEMP 3584 0 3584 DEV_IAS_TEMP 12672 […]
Read More