15.00 - Archive/Recovery Utility Support for Error Tables - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Archive/Recovery Utility Support for Error Tables

The following points apply to Archive/Recovery utility support for error tables:

  • An all-AMPs or dictionary archive includes all rows in DBC.ErrorTbls.
  • Error tables are archived only if they are contained by the database being archived.

  • When a database containing an error table is restored from either a cluster or all-AMPs archive, the corresponding row in DBC.ErrorTbls for the error table is also restored.
  • Table‑level archives do not include DBC.ErrorTbls rows.
  • An archived table can be restored only if it has not been dropped. You cannot restore a dropped error table.
  • If an error table has not been dropped, it is represented by a row in DBC.ErrorTbls, so restoring it from an archive does not require its DBC.ErrorTbls row to be restored as well.
  • Using the Archive utility COPY command to copy an error table does not restore its associated DBC.ErrorTbls row.
  • An error table copied using the Archive utility COPY command becomes a regular data table on the target system.
  • See Teradata Archive/Recovery Utility Reference for details about the COPY command.