Exclude Objects | Command Line | Teradata DSA - 17.20 - Excluding Objects - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2022-11-14
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
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 Analytics Database / 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
  Analytics Database 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.

  1. Open the XML file containing the job definition information.
  2. 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>