Table-Level Exclude Option with ARCHIVE - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

The table-level exclude object option is allowed in an ARCHIVE statement (and in COPY and RESTORE statements). This option is only accepted in a database-level object in a DATA TABLES of all-AMPs or cluster operations. A database-level object that has one or more excluded objects is a partial database.

An archive of a partial database contains the dictionary information and if the excluded object has data, the table header row of the excluded object. However, the actual data rows are not archived. If a partial database archive is restored, the table header row is restored for the excluded objects with data, but no data rows.

If an object is excluded, Teradata ARC restores the dictionary information and the table header row (if present), but leaves the table in restore state. This prevents the table from being accessed by another application before the table level restore is performed. A table-level restore for the excluded objects is expected to follow the partial database restore to fully restore a partial database.

If a table-level restore of the excluded object(s) is not going to be run, run a BUILD statement for the excluded objects. The excluded objects become accessible but empty, and can then be dropped.

If the ALL keyword is not specified after the object name, either non-qualified object names (without a database name prefix) or fully qualified object names (databasename.tablename) can be specified in the list of EXCLUDED TABLES. If a non-qualified object name is specified, it is presumed to belong to the source database that it is associated with. If the ALL keyword is specified after the object name, then only fully qualified object names in the form of databasename.tablename are accepted in the list of EXCLUDE TABLES.

Do not use EXCLUDE TABLES with the following options:

table level object: (db.tb) - DICTIONARY, JOURNAL, NO FALLBACK - AMP=.

Teradata ARC issues ARC0215 if any of the above conditions is detected.

For a list of individual object types that can be specified in the EXCLUDE TABLES clause for Archive, see Excluding Tables.

During a full database-level restore of an archive with excluded objects, the data dictionaries and the table headers of all objects, including excluded objects, are replaced. As a result, all of the existing rows in the excluded objects are deleted. To leave an existing excluded object intact during a restore or copy, use the EXCLUDE TABLES option in the RESTORE or COPY statement. For more details, see RESTORE and COPY.

Restoring individual objects from a database-level archive with excluded objects is supported. In the RESTORE statement, individually specify all the objects to be restored, except the excluded objects. By omitting the excluded objects, the data dictionaries and table headers of the excluded objects are preserved. The database is restored from the archive without altering the excluded objects.