Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or VALIDATE authority.
In the left pane, double-click Tables.
Right-click the table and click Validate.
Connect to the database as a user with DBA or VALIDATE authority.
Execute the VALIDATE TABLE statement:
VALIDATE TABLE table-name;
If errors are reported, you can drop all the indexes and keys on a table and recreate them. Any foreign keys to the table also need to be recreated.
If you suspect a particular index, you can execute an ALTER INDEX...REBUILD statement to rebuild the corrupted index. See ALTER INDEX statement.
Another solution for errors reported by VALIDATE TABLE is to unload and reload your entire database. You should use the dbunload -u option so that the unload process does not try to use a possibly corrupt index to order the data.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|