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.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.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.