Subject | Re: [firebird-support] Database corrupt - how to tell which index to rebuild |
---|---|
Author | Dmitry Yemanov |
Post date | 2006-07-17T14:38:11Z |
"Bob Murdoch" <mailgroups@...> wrote:
from RDB$INDICES
where RDB$RELATION_NAME = 'XRDS501' and RDB$INDEX_ID = 4
Dmitry
>select RDB$INDEX_NAME
> Index 4 is corrupt on page 3853736 in table XRDS501 (303)
>
> From previous experience, I know that I can alter the index
> inactive/active to rebuild it. However, how do I know exactly which
> index is "Index 4"?
from RDB$INDICES
where RDB$RELATION_NAME = 'XRDS501' and RDB$INDEX_ID = 4
Dmitry