Rename Child Database Tables | Teradata Data Mover - Renaming Tables in a Child Database - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
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>