Exclude Tables Object Types - 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
Exclude Tables Object Types 
Object type Exclude tables during archive Exclude tables during restore Exclude tables during copy
Table yes yes yes
CP Table yes yes yes
PPI Table yes yes yes
NOPI Table yes yes yes
Journal Table no no no
Queue Table yes yes yes
View no yes yes
Macro no yes yes
Trigger no yes yes
User-Defined Type (UDT) no no a no b
Glop no yes yes
Stored Procedures yes yes yes
External Stored Procedures yes yes yes
Java (JAR) procedure yes yes yes
Join Index yes b yes a yes a
Hash Index yes a yes a yes a
Authorization Function no yes yes
Standard (Scalar) Function (with data) yes yes yes
Standard (Scalar) Function (without data) no yes yes
Aggregate Function (with data) yes yes yes
Aggregate Function (without data) no yes yes
Statistical Function (with data) yes yes yes
Statistical Function (without data) no yes yes
AggrStat Function (with data) yes yes yes
AggrStat Function (without data) no yes yes
Table Function (with data) yes yes yes
Table Function (without data) no yes yes
Instant or Constructor Method (with data) yes no b no b
Instant or Constructor Method (without data) no no b no b
Parser Contract Function (with data) yes yes yes
Parser Contract Function (without data) no yes yes
Table Function (Operator) (with data) yes yes yes
Table Function (Operator) (without data) no yes yes
User Installed File (UIF) yes yes yes
Remote Server (without data) no yes yes
Schema (without data) no yes yes
a. The EXCLUDE TABLES clause can not be applied to SYSUDTLIB nor UDTs/UDMs. This is because UDTs/UDMs are stored in the SYSUDTLIB database and a restore/copy of SYSUDTLIB is not allowed

b. Do not specify these objects in the exclusion list, use SKIP JOIN INDEX instead.