Archive Daily Archives: February 1, 2014

Adding Temp File in Temporary tablespace ORA-01652: unable to extend temp segment by 128 in tablespace

. 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
Not found