Repair Data Corruption | Teradata Vantage - 17.00 - 17.05 - Repairing Data Corruption - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Advanced SQL Engine
Teradata Database
Release Number
June 2020
English (United States)
Last Update

Table Rebuild is a utility that repairs data corruption. It does so by rebuilding tables on a specific AMP vproc based on data located on the other AMP vprocs in the fallback cluster.

Table Rebuild can rebuild data in the following subsets:

  • The primary or fallback portion of a table
  • An entire table (both primary and fallback portions)
  • All tables in a database
  • All tables that reside on an AMP vproc

Table Rebuild performs differently based on the type of table (for example, fallback or not).

Type of Table Action
Fallback Tables Delete the table header (one row table which defines a user data table)

Delete specified portion of the table being rebuilt

Rebuild the table header

Rebuild the specified portion of the table

Non-fallback Tables Delete the table header.

Rebuild the table header.

Permanent Journal Tables Delete data for the table being rebuilt.

Rebuild the table header.

Locks the table pending rebuild.

You must restore non-fallback data.
You can start REBUILD when the failed AMP has been fixed and brought back to the OFFLINE state.