| SQL Error - Temp Segment... [message #23581] |
Wed, 18 December 2002 08:09  |
Rizwan Qazi
Messages: 135
Registered: August 2002
|
Senior Member |
|
|
Hi All,
I am generating a table with 403 fields with a long SQL query. The query ran for a while but then it failed with a message
ERROR at line 407:
ORA-01630: max # extents (121) reached in temp segment in tablespace DW
There is enough space in tablespace DW and the TEMP tablespace so why is this happening? What can I do to get around this?
Rizwan Qazi
|
|
|
|
| Re: SQL Error - Temp Segment... [message #23584 is a reply to message #23581] |
Wed, 18 December 2002 09:37  |
vivek
Messages: 59
Registered: October 2001
|
Member |
|
|
I am pasting the explanation of this error from the documentation. It is self explanatory. Hope it helps.
ORA-01630 max # extents (string) reached in temp segment in tablespace string
Cause: A temporary segment tried to extend past MAXEXTENTS.
Action: If MAXEXTENTS for the tablespace is less than the system maximum, you can raise that. Otherwise, raise PCTINCREASE for the tablespace
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
