ORA-01652: unable to extend temp segment

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Mon, 23 Jan 2006 13:31:02 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F705183976@irv2kexch01.tx.bg.corp>

SQL> alter index "SAPR3"."VBFA~0" rebuild online parallel 3 tablespace PSAPREROGI; *
ERROR at line 1:
ORA-12801: error signaled in parallel query server P001 ORA-01652: unable to extend temp segment by 89595 in tablespace PSAPREROGI

I got ORA-01652 while rebuilding the 14 GB index to a new tablespace and the tablespace has 16 GB free space. Before the error occurred, the 31 GB temp tablespace had 13.5 GB used.

Any idea why it created temp segments in the target tablespace? How big the target tablespace would be? I thought 16 GB is enough.

Thanks,

Roger

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_at_dp7uptx.com.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 23 2006 - 13:31:02 CST