OraFAQ Forum: Server Administration » 'Unable to extend segment temp by 128 in tablespace TEMP'

Home » RDBMS Server » Server Administration » 'Unable to extend segment temp by 128 in tablespace TEMP'

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

'Unable to extend segment temp by 128 in tablespace TEMP' [message #61576]

Thu, 06 May 2004 03:42

Kiran Tripurari
Messages: 1
Registered: May 2004

Junior Member

Hi, I am getting the following message whenever I am querying large amount of data from the database.

'Unable to extend segment temp by 128 in tablespace TEMP'

Pls help me asap. Thanx in advance.

Report message to a moderator

Re: 'Unable to extend segment temp by 128 in tablespace TEMP' [message #61580 is a reply to message #61576]

Thu, 06 May 2004 08:59

krishna b
Messages: 1
Registered: May 2004

Junior Member

you may need to resize the tempfile. the tempfile is running out of space and you my need to add more space. Hope this helps.
regards
Krishna

Report message to a moderator

Re: 'Unable to extend segment temp by 128 in tablespace TEMP' [message #61584 is a reply to message #61576]

Thu, 06 May 2004 12:15

Sanjay
Messages: 236
Registered: July 2000

Senior Member

Add more space in TEMP...

Report message to a moderator

Re: 'Unable to extend segment temp by 128 in tablespace TEMP' [message #61588 is a reply to message #61576]

Thu, 06 May 2004 18:39

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

Add datafile to the TEMP tablespace:

ALTER TABLESPACE TEMP
ADD TEMPORARY DATAFILE 'c:tempTEMP_DATA02.DBF'
SIZE 50K
AUTOEXTEND ON
NEXT 10K
MAXSIZE 100K;

Hope that helps,

Trifon Anguelov

DBAclick.com | DBA Forums

Report message to a moderator

Re: 'Unable to extend segment temp by 128 in tablespace TEMP' [message #61589 is a reply to message #61576]

Thu, 06 May 2004 20:19

KING
Messages: 9
Registered: February 2002

Junior Member

This could happen whenever your query has union or order by clause on a large resultset.
So make sure u have large temp space before executing such queries. also make sure u have proper index column used in the query.
Increase the size of temp tablespace. if it still occurs try to optimize the query!!!.

King

Report message to a moderator

Re: 'Unable to extend segment temp by 128 in tablespace TEMP' [message #62911 is a reply to message #61588]

Tue, 24 August 2004 01:10

jack He
Messages: 1
Registered: August 2004

Junior Member

i run it,but raise this error:ORA-00905:missing keyword

Report message to a moderator

Previous Topic:	export
Next Topic:	ORA-12560: TNS:protocol adapter error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 14:22:35 CST 2025