A. Data Dictionary Tables : Archive Table
 
Share this page                  
Archive Table
The archive table contains all the replicated columns in the base table, and the replicated transaction key, which is made up of the following information:
• Database number of the originating database
• Transaction ID
• Transaction sequence number
Each row in the archive table reflects a row that was in the shadow table.
This is an example of a replicated archive table:
Column Name
Data Type
Description
column1
integer not null
Primary key of a replicated table.
column2
varchar(20) not null
Other attribute of a replicated table.
sourcedb
smallint not null
Identifies the database where the transaction originated.
transaction_id
integer not null
Identifier given by the DBMS Server to the original transaction.
sequence_no
integer not null
The sequence of the operation (insert, update, delete) within the original transaction.