Home » RDBMS Server » Server Administration » ora-01652: unable to extend temp segment by 128 in tablespace TEMP
ora-01652: unable to extend temp segment by 128 in tablespace TEMP [message #228786] Wed, 04 April 2007 03:18 Go to next message
fares15_5
Messages: 1
Registered: April 2007
Junior Member
hi,
I'm in trouble guys could u please help me to solve it....

problem:
first of all, i have a DB called "wpsbp" V.: 9.2.0.4 and it has
user called "EAPPTMT".

I've ran an import to EAPPTMT schema(using fromuser...touser )but while the import utility is importing and creating a unique index
on HL7messages table (one of the tables is being imported) , an
ora-01652: unable to extend temp segment by 128 in tablespace TEMP shows up.
These are the errors:
IMP-00017: following statement failed with ORACLE error 1652:
---------------------------------------------------------------
CREATE UNIQUE INDEX "HL_MESSAGE_UN" ON
"HL7MESSAGES" ("HL7_MESSAGE" )
TABLESPACE "EAPPTMT_INDEX_TSPACE" LOGGING

IMP-00003: ORACLE error 1652 encountered
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
---------------------------------------------------------------and and then import utility completed the importing other tables and terminated successfully with warnings.

So, wt i did is that , i created a new temporary tablespace called 'temp02' and i added new datafile with size 500M bigger than the old temporary tablespace 'temp' that has DF with size 200M and i made it to be the default temporary TS and then i dropped the old one.

The command for creating the new temporary TS is:
CREATE
TEMPORARY TABLESPACE "TEMP02" TEMPFILE
'E:\ORACLE\ORA92\WEBPLAY\TEMP02.ora' SIZE 500M EXTENT
MANAGEMENT LOCAL UNIFORM SIZE 1024K;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP02";

and then i ran the create unique index
command again but i had the same error again which is
ora-01652


is there any way to git rid of this
could u please help me in that.


In the attachment u will see the log file for that import.
Re: ora-01652: unable to extend temp segment by 128 in tablespace TEMP [message #228794 is a reply to message #228786] Wed, 04 April 2007 04:13 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
ORA-01652 is caused when Oracle tries to allocate an extent for a temporary tablespace and can't do to lack of space. The solution is to use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Re: ora-01652: unable to extend temp segment by 128 in tablespace TEMP [message #228838 is a reply to message #228786] Wed, 04 April 2007 06:42 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Try increasing SORT_AREA_SIZE as well (if you are not using workarea_policy = auto).

HTH
Previous Topic: WCS-510 -- HTTP connection failed to URL
Next Topic: Finding sessions
Goto Forum:
  


Current Time: Wed Dec 07 12:22:38 CST 2016

Total time taken to generate the page: 0.05638 seconds