Re: Newbie Question

A copy of this was sent to "Erin Peterson" <ekp_at_nbnet.nb.ca> (if that email address didn't require changing) On Sat, 26 Feb 2000 15:20:02 GMT, you wrote:

>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.
>

every user in the database is assigned a temporary tablespace. We use this tablespace for disk based sorts, temporary result sets and the like.

The error message is saying in effect "your temporary tablespace is filled up". The DBA needs to add more space to this tablespace or you need to change your temporary tablespace setting (via the alter user command) to point to a tablespace with more room in it.

(there is no practical limit on the number of tables in a from clause -- i've tested upto 350 without error.)

>TIA,
>Erin Peterson
>

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Feb 26 2000 - 11:27:09 CST