TEMP Segments

From: Wayne S Bellefeuille <wbellefe_at_allina.com>
Date: Mon, 15 May 2000 11:14:43 -0500
Message-Id: <10498.105662@fatcity.com>

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. Received on Mon May 15 2000 - 11:14:43 CDT