You can rename tables in a restore job by adding rename_to to the table in the XML file containing the job definition.
- Open the XML file containing the job definition information.
-
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>