Restrictions and Limitations for Archive/Recovery and Partitioned Tables - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

You cannot restore or copy an archive that contains partitioned tables to an earlier release of Teradata Database that does not support row partitioning or column partitioning.

If you restore or copy a partitioned table to another system, you should revalidate the table headers on the target system after the restore or copy operation completes.

Because many of the ALTER TABLE MODIFY operations change the version number of tables, you cannot perform the following operations after modifying primary index partitioning, uniqueness, or column set members.
  • Cluster restores
  • Single AMP restores
  • Permanent journal rollforwards or rollbacks

If Archive/Recovery encounters such physical changes to a table during a rollforward or rollback operation, the operation stops and places an error message in the output listing.

The following table definition options and table definition-related operations performed by other statements do not invalidate future restorations of selected partitions for the targeted or referenced tables.

See ALTER TABLE (Basic Table Parameters) and CREATE TABLE (Table Options Clause) for more information about these options.

When the target and source are different systems, you must repeat each of the previously listed operations on the affected tables of the target system to ensure that the 2 are kept in synchrony.

See Rules for Retaining Eligibility for Restoring or Copying Selected Partitions for information about modifications to a table definition that do make future restore or copy operations of selected partitions for targeted or referenced tables non-valid.