Partial Failure During Table and Database Copy | Teradata Data Mover - About Partial Failures When Copying Tables and Databases - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Published
October 2021
Language
English (United States)
Last Update
2021-10-14
dita:mapPath
cai1626458602965.ditamap
dita:ditavalPath
cai1626458602965.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

A number of scenarios exist in which tables and databases in a job continue to be copied after a table or database copy fails.

Utility Used Objects Copied Scenario Result
TPTAPI Tables Table has an incorrect column name in its WHERE clause Table copy fails. Job continues and the remaining tables are copied to the target database.
TPTAPI Tables Source user does not have SELECT access to one of the tables Table copy fails. Job continues and the remaining tables are copied to the target database.