Topic
  • 1 reply
  • Latest Post - ‏2014-12-12T12:16:11Z by andreasl
pcifx
pcifx
1 Post

Pinned topic index error

‏2014-12-12T08:09:29Z |

Hello,

 

We are encountering the foll error:

an index of a table cannot grow given that no more extents are allowed

 

Can somebody pls help understand what does that error mean and how to resolve the same?

â€

Sorry, but at this moment I do not have any other detail. I only have so much detail and will post more details as soon I have gathered the same.

â€

thanks‹

  • andreasl
    andreasl
    30 Posts

    Re: index error

    ‏2014-12-12T12:16:11Z  

    Hello,

    the index' partition either has very many extents (filling the partition header page and not allowing for an additional one) or it has reached the 16mio pages size limit.

    Look at 'oncheck -pt <db_name>:<tabname>' output.

    Dropping and recreating the index might help.

    If the index indeed is so big that it will soon hit the 16mio pages limit, then please recreate it as fragmented index.

    HTH,

     Andreas