OraFAQ Forum: Server Utilities » ORA-01652: unable to extend temp segment by 8192 in tablespace IDX

Home » RDBMS Server » Server Utilities » ORA-01652: unable to extend temp segment by 8192 in tablespace IDX_TAB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01652: unable to extend temp segment by 8192 in tablespace IDX_TAB [message #531278]

Mon, 14 November 2011 22:22

prejib
Messages: 126
Registered: March 2009
Location: India

Senior Member

Hi..

I am doing an import job and the following error occurs during Index import.

What is the reason for this error? Kindly advice..

/Prejib..

Report message to a moderator

Re: ORA-01652: unable to extend temp segment by 8192 in tablespace IDX_TAB [message #531280 is a reply to message #531278]

Mon, 14 November 2011 22:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

01652, 00000, "unable to extend temp segment by %s in tablespace %s"
// *Cause:  Failed to allocate an extent of the required number of blocks for
//          a temporary segment in the tablespace indicated.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//          files to the tablespace indicated.

Report message to a moderator

Previous Topic:	Transportable tablespace.
Next Topic:	sql loader not creating bad file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 28 07:25:40 CST 2026