The object specified in the FROM keyword identifies the archive object. This option applies only during a copy of a dictionary archive or an all-AMPs archive.
Journal enabled tables in the original archive carry their journaling forward to the copy unless NO JOURNAL keywords are specified.
The NO JOURNAL keywords apply to all tables in a database when a database is copied. This option has no effect on a target database’s journaling.
If the object specified in the FROM option is a table, Teradata ARC copies only that table.
If the object specified in the FROM option is a database, one of the following occurs:
- If the receiving object is a table, then Teradata ARC searches through the archived database for the named table and copies the table.
- If the receiving object is a database, then Teradata ARC copies the entire database into the receiving database.
Copying into database DBC is not valid, however specifying database DBC as the object of the FROM option is valid. In other words, copy database DBC into another database.
Similarly, do not copy into database SYSUDTLIB. Specify database SYSUDTLIB as the object of the FROM option. That is, copy database SYSUDTLIB into another database.
When specifying the FROM and EXCLUDE TABLES options in the same COPY statement, specify the FROM clause first. Then Teradata ARC can generate a default source database name for the excluded tables from the FROM clause if a database name is not specified in the EXCLUDE TABLES clause.