You could try adding the word RECOVER to VALIDATE DATABASE after you make a backup.


>I have what is apparently an invalid database. Among the problems, some of the tables have an "Invalid primary key property." When I try to open the table, or alter it, I get an error telling me "Primary key property is invalid; please validate database." Issuing a VALIDATE DATABASE merely lists the problems, it doesn't solve them. How can I fix the primary key problem? Also, I need to be able to do it programmatically at a client's site.
>
>Thanks,
>Elyse