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
