Copy Operations for Objects and Data Table Archives | Teradata DSA - Copy Operations for Objects and Data Table Archives - BAR - Data Stream Architecture

Teradata® DSA User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2023-03-28
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
cyv1467242268519
Product Category
Software
Teradata Tools and Utilities

Copy Operations: 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: Join Indexes and System Join Indexes (SJIs)

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

Copy Operations: 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 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 the data temperature
  • Changing the data compression