Supported Database Objects - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
In general, you cannot copy any database objects that use features that exist in newer versions of Teradata Database to older versions of Teradata Database.
Database Object Name Older to Newer Versions Between Same Versions Newer to Older Versions Restrictions
Databases Can copy entire databases with Teradata ARC. See Copying an Entire Database.
Tables Yes Yes Yes

Cannot copy multi-set tables from newer to older systems when target only has 1 AMP or 1 AMP clusters (Teradata PT Update operator restriction).

Cannot use TPTAPI_LOAD to copy multi-set tables, if the allowTptLoadForMultiset table attribute is not set to true.

Full-table copies with tables that have show table output larger than 1MB are not supported. Show table is the text needed to reproduce the table definition. There is no limit to how much data the table can contain.

Cannot use Teradata ARC to copy tables from newer to older versions of Teradata Database.

Cannot use Teradata ARC if the override_lock_access parameter is set to true.

Cannot use Teradata ARC if the source and target TDPIDs are the same.

Global Temporary Tables Yes Yes Yes Cannot use online archive feature when using Teradata ARC.
Hash and Join Indexes Yes Yes Yes See Copying Join and Hash Indexes.
Macros Yes Yes Yes The underlying table must already exist on the target system or be copied with the job.
Permanent Journal Tables Yes Yes Yes See Copying Permanent Journals.
PPI Tables Yes Yes Yes Teradata ARC cannot copy partial tables that do not have Partitioned Primary Indexes.
Queue Tables Yes Yes No Teradata PT Export operator does not support queue tables.
Schema Yes Yes No

Schema is supported in Teradata Database 16.00 or later.

Teradata ARC and Teradata JDBC support copying tables with an associated schema object.

When copying a table that references a schema object, the schema object must either already exist on the target system or must be copied in the same job.

Data Mover does not relocate or rename schema objects.

Schemas are created only in the SYSUDTLIB database.

If you copy a schema with the same name that exists on the target system and overwrite_existing_objects is set to true, the schema is overwritten if no columns on the target system reference the schema.

Stored Procedures Yes Yes Yes The underlying table must already exist on the target system or be copied with the job.
Table Statistics Yes Yes Yes See About Copying Statistics.
Referencing Tables (parent/child) Yes Yes Yes See About Copying Tables with Referential Integrity.
Tables with LOB Columns Yes Yes Yes Teradata JDBC is used for newer to older versions of the Teradata Database. You cannot use Teradata JDBC to move tables with more than 15 LOB columns.

Teradata PT API does not support copying data in tables with LOB-based columns.

Tables with Identity Columns Yes Yes Yes Will not copy from newer to older versions if identity column defined with GENERATED ALWAYS statement.
Tables with User-Defined Type (UDT) Columns Yes Yes Yes UDT must already be defined on target system.

If a job copies a table with UDT columns, the source user and target user must have UDTUSAGE access to SYSUDTLIB to create the job. If a job copies a table with UDT columns and the job uses the Teradata ARC utility, there are no access restrictions for the target user.

Tables with XML, ST_Geometry, JSON Columns Yes Yes Yes Teradata ACR or Teradata JDBC supports copying tables with XML, ST_Geometry, or JSON column types.

Teradata JDBC is used for copying from newer to older versions of the Teradata Database.

Teradata PT API does not support copying data with these column types.

Due to syntax and format changes in Teradata Database 16.00, compare DLL fails for these column types when copying between systems where one system is prior Teradata Database 16.00 and the other is Teradata Database 16.00 or later.

Columnar Tables Yes Yes Yes

Columnar tables are supported in Teradata Database 14.00 or later. Columnar tables with Primary AMP index or Primary Index are supported only in Teradata Databases 15.10 or later.

Cannot force the use of TPTAPI_LOAD or TPTAPI_UPDATE.

Cannot force the use of ARC for partial table copies, whether or not they have Primary AMP index or Primary Index.

Triggers Yes Yes Yes See About Copying Triggers.
Views Yes Yes Yes You must use TPTAPI_UPDATE, TPTAPI_STREAM, T2T, or JDBC to copy view data. ARC cannot be used when source staging table is not in use. The TPTAPI_LOAD operator cannot be used.
Foreign Server Objects Yes Yes Yes You can copy foreign server objects only between Teradata Database 15.00 or later.
Users Yes Yes No User must already exist on the target Teradata system. Data Mover moves user objects as database objects. Only the objects within the user are moved. Passwords, permissions, and roles associated with the user are not moved. See About Copying Entire Databases.