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
Michael Helms
May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me
