RE: ORA-01652: unable to extend temp segment

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Mon, 23 Jan 2006 12:38:04 -0800 (PST)
Message-ID: <20060123203804.30113.qmail@web307.biz.mail.mud.yahoo.com>

For rebuild operations, twice the index space is used during the rebuild, as Oracle constructs the new index from the old one.

The space is released once the index is rebuilt.

Roger Xu <roger_xu_at_dp7uptx.com> wrote:

1 select INITIAL_EXTENT,
2 NEXT_EXTENT,
3 EXTENT_MANAGEMENT,
4 ALLOCATION_TYPE,
5 SEGMENT_SPACE_MANAGEMENT
6 from dba_tablespaces
7* where TABLESPACE_NAME = 'PSAPREROGI'
SQL> / INITIAL_EXTENT NEXT_EXTENT EXTENT_MAN ALLOCATIO SEGMEN
-------------- ----------- ---------- --------- ------
16384 40960 DICTIONARY USER MANUAL SQL>
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 23 2006 - 14:38:04 CST