-
Hi.
I'm getting this error.
ORA-1631 : max # extents 121 reached in table prod.xxx
How do I fix it?
Thanks
-
alter table xxx storage (maxextents unlimited);
Jeff Hunter
-
-
Is it advisable to set max extents to unlimited?
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
I would suggest looking at LMT's with extent management handled by the system itself.
There is no problem per se with setting maxextents unlimited; what would you do if you have to store LOB's in the DB itselg.
Nizar
-
Allowing the extents to be handled by the system on an LMT could lead to a fragmentation problem too.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Originally posted by marist89
alter table xxx storage (maxextents unlimited);
This is possible, and can give good result only if database has
DB_BLOCK_SIZE MORE THEN 2KB. If not, then oracle can't allocate
more then 121 extents for db objects.
In this case u should recreate table with more value in NEXT parameter.
-------------------------------------------
# of extents depend from DB_BLOCK_SIZE parameters.
-
Originally posted by Shestakov
This is possible, and can give good result only if database has
DB_BLOCK_SIZE MORE THEN 2KB. If not, then oracle can't allocate
more then 121 extents for db objects.
In this case u should recreate table with more value in NEXT parameter.
-------------------------------------------
# of extents depend from DB_BLOCK_SIZE parameters.
untrue.
Jeff Hunter
-
Originally posted by marist89
Originally posted by Shestakov
This is possible, and can give good result only if database has
DB_BLOCK_SIZE MORE THEN 2KB. If not, then oracle can't allocate
more then 121 extents for db objects.
In this case u should recreate table with more value in NEXT parameter.
-------------------------------------------
# of extents depend from DB_BLOCK_SIZE parameters.
untrue.
UNTRUE.
I know that exactly, because:
1) i had this problem a couple years ago with Oracle 8.0.5(may be 8.0.4)
2) i try to send link about this topic, but not today (this link at home). I hope tomorrow.
-
LINK:
http://otn.oracle.com/docs/products/...20_io.htm#3480
Table of # extents (depend from DB_BLOCK_SIZE)
Block Size (KB) Maximum Number of Extents
2 -- 121
4 -- 255
8 -- 504
16 -- 1032
32 -- 2070
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|