Home » RDBMS Server » Server Utilities » ORA-01652: unable to extend temp segment by 8192 in tablespace IDX_TAB
ORA-01652: unable to extend temp segment by 8192 in tablespace IDX_TAB [message #531278] Mon, 14 November 2011 22:22 Go to next message
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..
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 Go to previous message
BlackSwan
Messages: 26665
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.
Previous Topic: Transportable tablespace.
Next Topic: sql loader not creating bad file
Goto Forum:
  


Current Time: Sat Mar 28 05:56:19 CDT 2020