Rename Tables | Teradata Data Mover - Renaming Tables - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.00
Published
November 30, 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
gmn1574692806523.ditamap
dita:ditavalPath
cjo1509024828169.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
You can rename one or more tables on the target when you copy an entire database.
  1. Open the parameters.xml file that has the job definition information for the job.
  2. Under the database name, add the selection="included" attribute to the table element.
  3. Add a name element and enter the current name of the table.
  4. Add a target_name element and specify the new name for the table.
In the following example, the DBName.Orders table is renamed to DBName.Orders_Newname and DBName.Accounts is renamed to DBName.Accounts_2 on the target.
<database selection="included">
<name>DBName</name>
		<table selection="included">
			<name>Orders</name>
			<target_name>Orders_Newname</target_name>
		</table>
		<table selection="included">
			<name>Accounts</name>
			<target_name>Accounts_2</target_name>
		</table>
</database>
You can specify a staging database for the table to be renamed. In the following example, the DBName.Orders table is copied to the stage1 staging database and renamed to stage1.Orders_Newname.
<database selection= "included">
	<name>DBName</name>
		<table selection="included">
			<name>Orders</name>
    <staging_database>
     <name>stage1</name>
		  </staging_database>
    <target_name>Orders_Newname</target_name>
		  <staging_database>
  </table>
</database>