This option is required when copying journal images. Restore access privileges to each table that is necessary. Applying journal images to as many as 4096 tables is valid, however, all of the table names in the APPLY TO option cannot exceed 8 KB.
When a journal table is copied, Teradata ARC restores only checkpoint rows and those rows that apply to the receiving environment. The tables to which those images apply and their journaling options must have already been copied. Thus, to perform a COPY JOURNAL with an APPLY TO option, the appropriate COPY DATA TABLE statement must have been issued at least once prior to using COPY JOURNAL to establish the source/target tableid mapping in database DBC.DBCAssociation table. Teradata ARC copies only those images that have the correct table structure version (as defined by the originating table).
If a journal image for the source table is applied to more than one target table, Teradata ARC writes two occurrences of the journal image into the restored journal.