Hey Wayne... How is it going?
I am sure I can't give you any suggestions that you haven't tried already,
but did you coalesce the PMADTLX tablespace yet?
> -----Original Message-----
> From: Wayne S Bellefeuille [SMTP:wbellefe_at_allina.com]
> Sent: Monday, May 15, 2000 12:26 PM
> To: Multiple recipients of list ORACLE-L
> 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 - 12:26:17 CDT
