Copy Operations for Objects and Data Table Archives - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product
Data Stream Architecture
Release Number
16.00
Published
November 2016
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
zgh1474305420348.ditamap
dita:ditavalPath
3150_DSA_UG_1600.ditaval.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities

Copy Operations for Large Objects (LOBs)

You can copy tables that contain large object columns. You can also copy large object columns to a system that uses a hash function that is different from the hash function used for the copy operation.

Copy Operations for Join Indexes and System Join Indexes (SJIs)

You can restore and copy join indexes, hash indexes, and system join indexes to the same name. You can also copy system join indexes to a different database name.

Copy Operations for Data Table Archives

When you copy a data table to a new environment, Teradata DSA either creates a new table or replaces an existing table on the target Teradata Database.
  • DSA creates a new table if the target database does not have a table with the same name as the table being archived.
  • DSA replaces the table if the target database has a table with the same name. The existing table data and table definition on the target database are replaced by the data from the archive.
When table data is copied, the following changes are allowed:
  • Changing a fallback table to a non-fallback table
  • Changing the data temperature
  • Changing the data compression