Home » RDBMS Server » Server Administration » ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
ORA-01652: unable to extend temp segment by 64 in tablespace TEMP [message #119448] Thu, 12 May 2005 10:44 Go to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
http://www.arikaplan.com/oracle/ari4241.html

USeful source for ur query
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 Go to previous messageGo to next message
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
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 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: High Undo tilization by CJQ0 (merged 5)
Next Topic: ORA-15180 (merged)
Goto Forum:
  


Current Time: Mon Dec 05 08:45:13 CST 2016

Total time taken to generate the page: 0.06450 seconds