Always copy data tables before copying any associated journal tables. When a data table is copied to a new environment, Teradata ARC creates a new table or replaces an existing table on the target Teradata Database. COPY only replaces existing permanent journal tables; it cannot create permanent journal tables. For data table archives, note the following:
- If the target database does not have tables with the intended names, the copy operation creates them.
- If the target database has tables with the intended names, they are replaced by the archived table data. The existing table data and table definition are replaced by the data from the archive.
When copying data tables, these operations are allowed:
- Disabling journaling
- Specifying a journal table in a database different from the database that is receiving the table
- Changing a fallback table to a nonfallback table