| ORA-01630: max # extents (512) reached in temp segment in tablespace TEMP [message #51109] |
Fri, 26 April 2002 15:59  |
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  |
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);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
