Teradata ARC can copy (or restore) an object to a different Teradata Database environment. Use the COPY statement to:
- Replace an object in a target database
- Create an object in a target database
- Move an archived file to a different Teradata Database other than the one from which the archive was made
- Move an archived file to the same Teradata Database from which the archive was made
The ability to copy all objects as individual objects is a feature of TTU 13.00.00 and later. Triggers cannot be copied. For a complete list of objects supported by Teradata ARC, see Database Objects.