You can validate a table using Sybase Central.
You must have the VALIDATE ANY OBJECT system privilege. It is best to validate when there is no other activity on the table.
Contexte et remarques
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.
Another solution for errors reported by the VALIDATE TABLE statement 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.
Use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, double-click Tables.
Right-click the table and click Validate.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|