Re: ora_01631max # of extents nnn reached in table table-name
Originally posted by Ablakios
According to the documentation .....
For a 8K block size an object could have no more than 505 extents
Which documentation are you reading? Those limits of maxextents based on db block size are ancient history, from times of earlier releases of Oracle7!
The upper limit for maxextents is UNLIMITED, and this "unlimited value" in the database is represented by that large number which you are getting (2147483645).
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Reply With Quote