0 Replies Latest reply: Mar 15, 2013 9:07 AM by 995166 RSS

    error "Error:ORA-01652: unable to extend temp segment by 8192 tablespace

    995166
      Hi expert,
      I am trying to create new table by using select statement as below
      {create table abc as select column1,column2... from xyz} and table xyz has huge volumn of data so I am getting error
      Error:ORA-01652: unable to extend temp segment by 8192 in tablespace. Please advice if I create table abc with same stucture of xyz then If i insert data into abc, can I avoid this error? what is better apporach to consider performance wise and memory wise. please advice. Thanks in advance.