Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Error

Re: SQL Error

From: Jim Smith <usenet_at_ponder-stibbons.com>
Date: Thu, 30 Nov 2006 11:08:04 +0000
Message-ID: <rkoepSoUurbFFwA6@jimsmith.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US