Wayne,
Hmm, I've always used the technique you described
below to force SMON to wake up and it's worked like a
charm. I'm assuming that by "It blew up on the NEXT
extent" you mean that it did not give you an ORA-1658.
I'm also assuming you created the dummy table in the
same tablespace.
SMON won't clean up these extents if there's still a
session locking them. Is it possible you have another
session that has locks on them (e.g. a client session
that was killed, but its Unix shadow process hasn't
been killed)? Also keep in mind that when
creating/rebuilding an index the segments are
temporary and aren't converted to permanent until the
index creation is complete. The same thing happens on
a drop. Do you have any other sessions creating
indexes in that tablespace at the same time?
HTH,
- Anita
- Wayne S Bellefeuille <wbellefe_at_allina.com> wrote:
> 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).
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Mon May 15 2000 - 15:09:35 CDT