15.11 - Copy Restrictions - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Data Stream Architecture
December 2016
User Guide
To use the copy operation, the following conditions must be met:
  • Restore access privileges on the target database or table are required.
  • A target database must exist to copy a database or an individual object.
  • When copying a table that does not exist on the target system, you must have CREATE TABLE and RESTORE database access privileges for the target database.

No Support for Copying DBC Database

Teradata DSA does not support copying the DBC database, which must be restored after a successful Teradata Database system initialization. Refer to Restoring DBC and User Data for the process to restore the DBC database.

No Support for Copying SYSUDTLIB Database

Teradata DSA does not support copying the SYSUDTLIB database, which is restored when the DBC database is restored.

Restriction on Copying TD_SERVER_DB Database

In Teradata Database 15.10 and higher, the TD_SERVER_DB database cannot be copied to a different name.