You can exclude objects from a backup or restore job by amending excludeobjectinfo in the XML file containing the job definition.
The following restrictions are true for backup or data migration jobs:
| Version of DSA | Teradata NewSQL Engine / Teradata Database | Restricted Objects |
|---|---|---|
| Prior to DSA 16.20 | Any | Cannot exclude individual: VIEW, MACRO, TRIGGER, JOIN_INDEX, HASH_INDEX |
| DSA 16.20 | Teradata Database prior to 16.20 | Cannot exclude individual: VIEW, MACRO, TRIGGER, JOIN_INDEX, HASH_INDEX |
| Advanced SQL Engine 16.20 or later | Cannot exclude individual: JOIN_INDEX or HASH_INDEX Use the job level option skip_joinhash_index to skip join and hash index. See create_job. |
- Open the XML file containing the job definition information.
-
Under excludeobjectinfo, specify the object name and object type that you want to exclude.
For example, to exclude tables T1 and T2 from a job that restores database ABC:
<objectinfo> <object_name>ABC</object_name> <object_type>DATABASE</object_type> <parent_name>SYSTEMFE</parent_name> <parent_type>DATABASE</parent_type> <!-- Optional --> <exclude> <excludeobjectinfo> <object_name>T1</object_name> <object_type>TABLE</object_type> </excludeobjectinfo> <excludeobjectinfo> <object_name>T2</object_name> <object_type>TABLE</object_type> </excludeobjectinfo> </exclude> </objectinfo>