Checkpoint Revalidate

The REVALIDATE option regenerates the table headers for a partitioned table or uncompressed join index and optionally verifies and corrects the row partitioning for a table (but not for a join index) if you specify the WITH DELETE or WITH INSERT null partition handling options.
You can specify the REVALIDATE option for unpartitioned tables and join indexes without also specifying PRIMARY INDEX. This makes revalidation applicable whether or not the table or join index has a primary index.
You must specify the REVALIDATE option without also specifying PRIMARY INDEX for NoPI tables and column‑partitioned tables and join indexes. Otherwise, Teradata Database aborts the request and returns an error to the requestor.
The REVALIDATE option also provides the ability to revalidate some data dictionary columns.
REVALIDATE requests do not verify the column partitioning of a column‑partitioned table or join index.
If partitioning errors are detected for a table (but not a join index), an ALTER TABLE REVALIDATE request corrects them.
REVALIDATE also revalidates the following Data Dictionary table columns.

wave web technology was established in 2012, and has a dynamic team of professional web developers,
web designers, SEO experts and customer support .
website : www.wavewebtech.com
https://www.facebook.com/wavewebtechnologies
https://twitter.com/wavewebtechnolo
https://plus.google.com/collections/