From: Chuck Hamilton Newsgroups: comp.databases.oracle.server Subject: Re: Help with temp tablespace problem Date: Wed, 08 Aug 2001 11:38:33 -0400 Lines: 31 Message-ID: References: <9kpd55$hgm$1@panix3.panix.com> NNTP-Posting-Host: 207.140.171.61 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: fu-berlin.de 997285115 2936376 207.140.171.61 (16 [85580]) X-Newsreader: Forte Agent 1.8/32.548 On 7 Aug 2001 14:48:05 -0400, stanb@panix.com (Stan Brown) wrote: >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. > This is probably not a temp tablespace problem any more. You need to either increase the max extents to unlimited, or better yet, increase the initial and next extent sizes on your table to something much larger. -- Chuck Hamilton chuck_hamilton@yahoo.com "Do not be deceived, God is not mocked; for whatever a man sows, this he will also reap." (Gal 6:7 NASB)