In this example, an archived data table is copied under a new database name to a different Teradata Database:
COPY DATA TABLE (Personnel.Department) (FROM (OldPersonnel), NO JOURNAL, NO FALLBACK) ,FILE = ARCHIVE;
In this example:
- The new database name is Personnel; the old database name is OldPersonnel. In both databases, the table name is Department.
- If a database named Personnel does not exist in the target system, Teradata ARC rejects the copy operation.
- If a data table named Department does not exist in the Personnel database on the target system, Teradata ARC creates one with that name.
- The NO JOURNAL option indicates that this table should not have permanent journaling in the target database.
- The NO FALLBACK option indicates that the new table should be nonfallback on the target system, even if it was a fallback table on the archived system.