OraFAQ Forum: Server Administration » ORA-01652: unable to extend temp segment by 64 in tablespace TEMP

Home » RDBMS Server » Server Administration » ORA-01652: unable to extend temp segment by 64 in tablespace TEMP

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

ORA-01652: unable to extend temp segment by 64 in tablespace TEMP [message #119448]

Thu, 12 May 2005 10:44

oskarthik
Messages: 26
Registered: March 2005

Junior Member

im using oracle 817 and when i try 2 insert into a table i get these following errors ?

ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
ORA-27059: skgfrsz: could not reduce the file size

What might b the problem?
and what is to b done ?

TIA,
karthik

Report message to a moderator

Re: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP [message #119456 is a reply to message #119448]

Thu, 12 May 2005 11:07

oskarthik
Messages: 26
Registered: March 2005

Junior Member

i even added a datafile to the temp TS. but stil i get the same errors.
any idea
TIA,
Karthik

Report message to a moderator

Re: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP [message #119555 is a reply to message #119456]

Fri, 13 May 2005 06:13

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

http://www.arikaplan.com/oracle/ari4241.html

USeful source for ur query

Report message to a moderator

Re: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP [message #419376 is a reply to message #119448]

Fri, 21 August 2009 11:57

nitinkumarbe
Messages: 8
Registered: June 2009

Junior Member

Hi

I followed the steps mentioned in the article http://technotes.towardsjob.com/oracle/ora-01652-unable-to-extend-temp-segment-by-64-in-tablespace/ and i can able to get thorough the error. Please try and let me know if it works

Thanks
Nitin

Report message to a moderator

Re: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP [message #419379 is a reply to message #419376]

Fri, 21 August 2009 12:25

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you really expect he will answer you after more than 4 years.
I think if he didn't solve his problem yet, he gave up long ago.

Regards
Michel

Report message to a moderator

Previous Topic:	High Undo tilization by CJQ0 (merged 5)
Next Topic:	ORA-15180 (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 10 05:35:35 CST 2025