Just increase the Tempory tablespace. NT. vrs_manian <vrs_manian@xxxxxxxxx> wrote: Hi, I was running a query on my database and faced with this error. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP How do I handle this ? Regards, Ram Yahoo! Groups SponsorADVERTISEMENT document.write(''); --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/dba_gurus/ To unsubscribe from this group, send an email to: dba_gurus-unsubscribe@xxxxxxxxxxxxxxx Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? All your favorites on one personal page ? Try My Yahoo!