Renaming Tables in a Child Database - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
  1. Add the selection="included" attribute to the table element.
  2. Specify the name of the source table.
  3. Specify the renamed target table with the target_name element.
In the following example, MyDatabase and all its children are copied to the target, but the MyDatabase_child.ORDERS table is renamed to MyDatabase_child.ORDERS_NEWNAME on the target.
<database selection="all"> 
<name>MyDatabase</name> 
	<database selection="included"> 
	<name>MyDatabase_child</name> 
		<table selection="included"> 
			<name>ORDERS</name> 
			<target_name>ORDERS_NEWNAME</target_name> 
		</table> 
 </database> 
</database>