>I am having problem on database consistency error when the database that being operation shut down abnormally. When i restart the database again, i will get the error that mention above ? Is there any function or command such as re-index or re_initialise the database ? Can anybody help me on that issue ? I am having this problem for quite some time that i required to solve for my customer. Thank You.
>
>Leong
Try to open the database exclusively. If you can, then do a VALIDATE DATA RECOVER command. If you can't open the database at all, you should probably use a backup copy of your DBC, DCX and DCT files. This will NOT affect your data unless one or more of your tables was damaged at the same time.
HTH
Barbara