ORA-01652: unable to extend temp segment 2006-01-23 - By Roger Xu
But I tried to rebuild from the old tablespace to a new tablespace? Thanks.
-- --Original Message-- --
From: Joseph Amalraj [mailto:joseph@(protected)]
Sent: Monday, January 23, 2006 2:38 PM
To: Roger Xu; Michael McMullen; Oracle-L@(protected) Org (E-mail)
Subject: RE: ORA-01652 (See ORA-01652.ora-code.com): 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@(protected)> 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@(protected) 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.
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____
This email has been scanned for all viruses by the MessageLabs Email Security
System. Any questions please call 972-721-8257 or email your request to tech
_support@(protected)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=563123920-23012006><FONT face=Arial color=#0000ff size=2>But I
tried to rebuild from the old tablespace to a new tablespace?
Thanks.</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B> Joseph Amalraj
[mailto:joseph@(protected)]<BR><B>Sent:</B> Monday, January 23, 2006 2:38
PM<BR><B>To:</B> Roger Xu; Michael McMullen; Oracle-L@(protected) Org
(E-mail)<BR><B>Subject:</B> RE: ORA-01652 (See ORA-01652.ora-code.com): unable to extend temp
segment<BR><BR></FONT></DIV>
<DIV>For rebuild operations, twice the index space is used during the rebuild
,
as Oracle constructs the new index from the old one.</DIV>
<DIV> </DIV>
<DIV>The space is released once the index is rebuilt. <BR><BR><B><I>Roger Xu
<roger_xu@(protected)></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<BR>1
select INITIAL_EXTENT,<BR>2 NEXT_EXTENT,<BR>3 EXTENT_MANAGEMENT,<BR>4
ALLOCATION_TYPE,<BR>5 SEGMENT_SPACE_MANAGEMENT<BR>6 from
dba_tablespaces<BR>7* where TABLESPACE_NAME = 'PSAPREROGI'<BR>SQL>
/<BR><BR>INITIAL_EXTENT NEXT_EXTENT EXTENT_MAN ALLOCATIO
SEGMEN<BR>-- ---- ------ -- ---- --- -- ---- -- -- ------ -- ---<BR>16384
40960 DICTIONARY USER MANUAL<BR><BR>SQL><BR><BR></BLOCKQUOTE><BR>For
technical support please email tech_support@(protected) or you can<BR>call
(972)721-8257. <BR>This email has been scanned for all viruses by the
MessageLabs Email Security System.<BR></BLOCKQUOTE>
<BR>
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.
<BR>
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____<BR>
This email has been scanned for all viruses by the MessageLabs Email Security
System. Any questions please call 972-721-8257 or email your request to tech
_support@(protected)<BR>
</BODY></HTML>
|
|
