WITH JOURNAL TABLE Keywords - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

This option only applies during a copy of a dictionary archive or an all-AMPs archive. To use this option, INSERT access privileges to the referenced journal table are required.The source table must have a journal or this option has no effect.

When copying a database, the journaling specified with this option applies only to those tables that had journaling enabled in the original database. This option has no effect on a receiving database’s default journaling.

If the database has default journaling specified, Teradata ARC uses those options. This option only overrides the journal table in the receiving database, and is only valid if the originating table had journaling enabled.

To carry journaling from the original table forward without specifying the WITH JOURNAL TABLE option, Teradata ARC uses one of the following:

  • The default journal of the receiving database if the table is to be created. If there is no default journal, Teradata ARC rejects the copy.
  • The journal specified in the WITH JOURNAL option when the table was created.
  • The journal of the table being replaced if the table already exists.