Try rebuildliing all of the other indexes first and then go back to these.
Then you may have enought segments. It works for me. RBG
----- Original Message -----
From: Wayne S Bellefeuille <wbellefe_at_allina.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Monday, May 15, 2000 1:26 PM
Subject: TEMP Segments
> Running Oracle 8.0.5 on AIX...
>
> In doing rebuilds of indexes, I am blowing up with the following error:
> ORA-01652: unable to extend temp segment by 2048 in tablespace PMADTLX
>
> In retrying, the rebuild, I get this message:
> ORA-01658: unable to create INITIAL extent for segment in tablespace
PMADTLX
>
> In looking at DBA_SEGMENTS, there are a whole bunch of TEMPORARY segment
types
> hanging out in tablespace PMADTLX. I thought SMON should clean up these
> TEMPORARY segments automatically.
>
> I am assuming this is a bug in Oracle, but thought I would ask around.
>
> Anyone know a full-proof "trick" to get rid of these. I tried creating a
dummy
> table with a small INITIAL and big NEXT with MINEXTENTS 2. It blew up on
the
> NEXT extent, but did not clean up the tablespace.
>
> Wayne
>
> --
> Author: Wayne S Bellefeuill
> INET: wbellefe_at_allina.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 15 2000 - 13:46:28 CDT
