Re: Help with temp tablespace problem

"Stan Brown" <stanb_at_panix.com> wrote in message news:9kpd55$hgm$1_at_panix3.panix.com...
> I'm trying to run a slect that involves an ORDER BY on a table with over 1
> million rows.
>
> I originaly got an error message about not being able to extend the
 TEMP_TS
> tablespace. So I looked around and found a 500MB tablespace that I had
> created for a test a while back, and that has since been completly emptied
> out. I did a ALTER USER to set the user I was runig as temporary tablespce
> to this tablespace, and thought everything would be fine. Unfortunately,
> now I am geting this error message:
>
> ORA-01630: max # extents (121) reached in temp segment in tablespace
 GNUMETRICS_TS
>
> What do I need to do to allow the use of larger temporary segments in this
> new tablespace?
>
> Oracle 7.3.4, if it matters.
>
>

alter tablespace <tablespace_name>
default storage (maxextents unlimited)

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 07 2001 - 16:38:46 CDT