Home » RDBMS Server » Server Administration » ORA-01630: max # extents (512) reached in temp segment in tablespace TEMP
ORA-01630: max # extents (512) reached in temp segment in tablespace TEMP [message #51109] Fri, 26 April 2002 15:59 Go to next message
George
Messages: 68
Registered: April 2001
Member
Hi,

I get
ORA-01630: max # extents (512) reached in temp segment in tablespace TEMP
when I run the DBMS_STATS.GATHER_SCHEMA_STATS('ORCL')
From the dba_free_space, there are lots free space:

TEMP 12 23857 14286848 1744 12
TEMP 12 23467 532480 65 12
TEMP 12 2342 4792320 585 12
TEMP 12 2 18636800 2275 12
TEMP 12 19892 1597440 195 12
TEMP 12 20152 20234240 2470 12
TEMP 12 22687 5324800 650 12
TEMP 12 2992 108093440 13195 12
TEMP 12 16317 28753920 3510 12

Could you help me to fix this problem?

Thanks
Re: ORA-01630: max # extents (512) reached in temp segment in tablespace TEMP [message #51194 is a reply to message #51109] Mon, 06 May 2002 12:30 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
01630, 00000, "max # extents (%s) reached in temp segment in tablespace %s"
// *Cause: A temp segment tried to extend past max extents.
// *Action: If maxextents for the tablespace is less than the the system
// maximum, you can raise that. Otherwise, raise pctincrease for the
// tablespace

INCREASE THE 'MAXEXTENTS' PARAMETER FOR THAT TABLESPACE.

alter tablespace temp default storage (maxextents 5000);
Previous Topic: urgent..how to disable archiving
Next Topic: How do I strip oracle off an UNIX sun box
Goto Forum:
  


Current Time: Wed Dec 25 10:33:18 CST 2024