ALL FROM ARCHIVE Keywords - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

The ALL FROM ARCHIVE keywords take the place of the database and/or table names that are normally specified after the DATA, DICTIONARY, JOURNAL, or NO FALLBACK TABLES keywords.

Do not specify any other database or table names to be copied when using ALL FROM ARCHIVE. Exercise caution when using this option, as all databases and tables in the given archive file will be copied, and any existing databases or tables will be overwritten.

CATALOG and Fastpath are not supported while using ALL FROM ARCHIVE. If CATALOG (or Fastpath) is enabled when ALL FROM ARCHIVE is specified, it will be disabled and a warning message will be given.

ALL FROM ARCHIVE cannot be used to copy database DBC, and database DBC must be excluded by the user if it is present in the archive being copied.

COPY supports the EXCLUDE option; the syntax and function of the option is identical to the RESTORE version of EXCLUDE. Unlike RESTORE, COPY only supports the EXCLUDE option when using ALL FROM ARCHIVE.

The FROM, WITH JOURNAL TABLE, APPLY TO, and EXCLUDE TABLES object options are not allowed when using ALL FROM ARCHIVE.

The ALL FROM ARCHIVE command cannot be used to copy a table that has a join or hash index defined or a database that contains a table that has such indexes defined. See Join and Hash Indexes in Restoring.