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 - 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

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.