Renaming Tables - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product
Data Stream Architecture
Release Number
16.10
Published
August 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
mbk1487616377418.ditamap
dita:ditavalPath
3150_DSA_UG_1610.ditaval.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
You can rename tables in a restore job by adding rename_to to the table in the XML file containing the job definition.
  1. Open the XML file containing the job definition information.
  2. Under objectinfo, identify the table to rename and add the new table name inside rename_to. In the following example, table T1 in the ABC database is restored and renamed as T2:
    <objectinfo>
        <object_name>T1</object_name>
        <object_type>TABLE</object_type>
        <parent_name>ABC</parent_name>
        <parent_type>DATABASE</parent_type>
        <object_attribute_list>
            <rename_to>T2</rename_to>
        </object_attribute_list>
    </objectinfo>