Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01652: unable to extend temp segment
But I tried to rebuild from the old tablespace to a new tablespace? Thanks.
-----Original Message-----
From: Joseph Amalraj [mailto:joseph_at_amalrajinc.com]
Sent: Monday, January 23, 2006 2:38 PM
To: Roger Xu; Michael McMullen; Oracle-L_at_Freelists. Org (E-mail)
Subject: RE: ORA-01652: unable to extend temp segment
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>
For technical support please email tech_support_at_dp7uptx.com or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.
![]() |
![]() |