Re: Newbie Question

There is an order by or group by or count or anything else in your statement requiring sorting and/or hashing on disk. This done by creating a temporary segment in a tablespace in this case the tablespace temp.
The message is saying Oracle needs 128 blocks extra for this purpose (and maybe more) and that space is not available.

That said, without knowing the exact configuration of that tablespace, it is difficult to help you out.

Regards,

Sybrand Bakker, Oracle DBA

Erin Peterson <ekp_at_nbnet.nb.ca> wrote in message news:CaSt4.615$oQ4.14330_at_sodalite.nbnet.nb.ca...
> Hi all. I'm new to Oracle and I have a relatively newbie-like question to
> ask.
>
> I am connecting to an Oracle 8.05 database through PowerBuilder 6.5 and
when
> I run a particularly complex SQL Select, I get the following error:
>
> "Select Error: ORA-01652: unable to extend temp segment by 128 in
> tablespace TEMP"
>
> I cut and pasted the SQL that I built in PowerBuilder into my Oracle
client
> software, ran the Select and still got the same error. Like I said, the
> Select is fairly complex and uses 7 tables in the FROM clause. Have I
> overrun some Oracle restraint on the number of joined tables that I can
use
> in the Select? Or is the problem something like a full transaction log or
> something along that line?
>
> Again, this is probably a pretty newbie question so I apologize but the
> danger of working on Saturday is that the DBA is never around when you
need
> him.
>
> TIA,
> Erin Peterson
>
>
Received on Sat Feb 26 2000 - 10:37:31 CST