Rename Tables | Teradata Data Mover - Renaming Tables - 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
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>