Re: SQL - Oracle Error

beersa wrote:
> 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/Beer

Search asktom.oracle.com for ora-01652 for a couple of things it could be, aside from actually not having enough space. Is your temp ts really temp? See v$sort_usage and v$sort_segment. Maybe someone else (ie, something you thought you killed) is using up space. Maybe you aren't closing cursors you should be, or are using global temporary tables, or... Do you have pga_aggregate_target set?

jg

-- 
@home.com is bogus.
http://www.crashbonsai.com/gallery3.html