Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Error
In message <1164880240.766988.275840_at_14g2000cws.googlegroups.com>,
beersa <sabeer.sabeer_at_gmail.com> writes
>Hello,
>
>I am using WinXP Home Pro with Oracle Client 9. The oracle server also
>ver 9.
>
>I've got an error after long running SELECT query . The error is
>ORA-01652: unable to extend temp segment by 16 in tablespace TEMP
>
>Thanks!!
>
>Rgds/Sabeer
>
Your query is using temporary space for sorting and has run out of
space. You can either
- extend the TEMP TABLESPACE
- rework the query to use fewer resources
-- Jim Smith Ponder Stibbons Limited <http://oracleandting.blogspot.com/> RSS <http://oracleandting.blogspot.com/atom.xml>Received on Thu Nov 30 2006 - 05:08:04 CST
![]() |
![]() |