Tag Archives: unable to extend temp segment

ORA-01652: unable to extend temp segment: Solutions

Last updated on July 10th, 2019 at 05:21 am We receive this error  ORA-01652 while inserting data,creating index, table when we don’t have enough space in tablespace. Solution is to add sufficient space in the tablespace identified in the error ORA-01652 There are three ways to do  it Add datafile Resize the existing datafile auto-extent the datafile This can happen with permanent tablespace  and Temporary … Continue reading ORA-01652: unable to extend temp segment: Solutions »