The COPY statement copies a database or table from an archived file to the same or different Teradata Database from which it was archived.
Use COPY to move data from an archived file back to the Teradata Database. The target database must exist on the target Teradata Database, however COPY creates a new table if it does not already exist on the target database. If a copy of selected partitions is requested, the target table must exist on the target Teradata Database.
COPY between the same database version is supported. COPY from an older database version to a newer database version is supported. COPY of a newer database version back to an older database version is not supported.
Beginning with TTU 13.00.00, there is support for copying all objects as individual objects. Triggers cannot be copied. For a complete list of objects supported by Teradata ARC, see Database Objects.