OraFAQ Forum: Server Administration » analyse command returns ORA-01652: unable to extend temp segment by

Home » RDBMS Server » Server Administration » analyse command returns ORA-01652: unable to extend temp segment by

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

analyse command returns ORA-01652: unable to extend temp segment by [message #62498]

Sat, 24 July 2004 05:18

ramya
Messages: 87
Registered: August 2002

Member

hi

when i run the� analyze comand

analyze table ta.sales compute statistincs

i got this error

analyze table ta.sales compute statistincs

*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 207381 in tablespace TEMP

i checked the table storage parmenter it gave

initial ext10240�� next extent� 955613184

i checked the temp tablespace it have 1000mb and i added 500mb more after reissuing this command i got same error with following number.WHat exactly hppneing with temp segments it will do some sorting but why this error

ERROR at line 1:
ORA-01652: unable to extend temp segment by 311072 in tablespace TEMP

what its meant by segment by 311072

with regards

ramya

�

�

�

Report message to a moderator

Re: analyse command returns ORA-01652: unable to extend temp segment by [message #62499 is a reply to message #62498]

Sun, 25 July 2004 03:20

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

Your next extent value is way to large! After using the initial 10K (10240 bytes), Oracle needs to allocate 911M (955613184) of contiguous space to the second extent.

Code: [Select all] [Show/ hide]

ALTER TABLESPACE temp DEFAULT STORAGE (INITIAL 10M NEXT 10M);

Best regards.

Frank

Report message to a moderator

Re: analyse command returns ORA-01652: unable to extend temp segment by [message #62521 is a reply to message #62499]

Mon, 26 July 2004 07:59

ramya
Messages: 87
Registered: August 2002

Member

dear sir
whether i have to alter the storage parameters of
temp or the concerned table have next extent around 910
mb
wiht regards
ramya

Report message to a moderator

Re: analyse command returns ORA-01652: unable to extend temp segment by [message #62554 is a reply to message #62521]

Wed, 28 July 2004 12:47

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

Not sure I understand your question. However, you cannot alter the storage parameters of a temporary segment. So, do it on tablespace level.

Best regards.

Frank

Report message to a moderator

Previous Topic:	drop Oracle 8i server database
Next Topic:	Datafile-Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 14:45:10 CDT 2025