Exclude Tables Object Types - TARA/ABU

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¹

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²

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