Hi.
I'm getting this error.
ORA-1631 : max # extents 121 reached in table prod.xxx
How do I fix it?
Thanks
Printable View
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);
Thanks Jeff.
Is it advisable to set max extents to unlimited? ;)
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
This is possible, and can give good result only if database hasQuote:
Originally posted by marist89
alter table xxx storage (maxextents unlimited);
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.Quote:
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.Quote:
Originally posted by marist89
untrue.Quote:
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.
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