Re: HELP!! URGENT!! Need help on administration !! Oracle 7.3.2

From: <tedchyn_at_yahoo.com>
Date: Sat, 09 Jan 1999 16:04:19 GMT
Message-ID: <777um2$g1a$1@nnrp1.dejanews.com>

In article <369c5869.32758263_at_netnews.worldnet.att.net>,   gennick_at_worldnet.att.net wrote:
> If your query is doing a sort, then the TEMP tablespace
> would be used. However, when the query was done, the space
> would be released.
>
> Try restricting the WHERE clause of your query so that it
> returns fewer records. If that makes the error go away, then
> you just need to add more space to TEMP.
>
> Jonathan
>
> On Thu, 07 Jan 1999 12:59:09 GMT, t.klinger_at_mobilkom.at
> (Thomas Klinger) wrote:
>
> >Help!
> >
> >I wanted to run a query (normally this one already worked) but my
> >server gives back an error.
> >
> >ORA-1652: unable to extend temp segment by 4982 in tablespace TEMP
> >
> >This I understand but there are NO tables in our TEMPspace currently
> >(looked with 'select * from all_tables where tablespace_name='TEMP';'
> >as system).
> >
> >And there are still over 12000 blocks free! So, also the
> >PERCENTAGE_INCREASE 50% is no prob. Diskspace enough, no data in
> >TEMP-tablespace, enough space in the tablespace itself, the error
> >happens each time.
> >
> >BTW: The query was already in use!
> >
> >Why?
> >
> >
> >Kind regards
> >
> > Thomas Klinger
> > Systemspecialist
> >=======================================
> >t.klinger_at_mobilkom.at
> >http://www.mobilkom.at
> >=======================================
> >
> >
>
>

---

Thomas, this happens quite often when you have a cartesian product resulting from missing where clause on the joined column(s).

Ted Chyn

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Jan 09 1999 - 10:04:19 CST