13.2.8.  Objects created by incremental snapshot replication

Table "DB.DBA.RPLOG_<name>" (replay log) is created in Virtuoso database for replayed snapshot log entries.

Table "RLOG_<name>" (snapshot log) is created in the source DSN. This table is attached as "<qual>"."<dsn>"."RLOG_<name>" if source table is an attached table. Other objects created by incremental snapshot replication in the source DSN are:

  • Virtuoso Triggers "<qual>_<owner>_<name>_I_log", "<qual>_<owner>_<name>_U_log" and "<qual>_<owner>_<name>_D_log" on replicated table.
  • SQL Server Triggers "<name>_I_log", "<name>_U_log" and "<name>_D_log" on replicated table.
  • Oracle Triggers "<name>_I_log", "<name>_U_log" and "<name>_D_log" on replicated table. Function OPL_GETUTCDATE().
  • DB2 Triggers "<name>_I", "<name>_U" and "<name>_D" on replicated table. Sequence opl_seq_rowguid.
  • Informix Triggers "<name>_I_log", "<name>_U_log" and "<name>_D_log" on replicated table. Sequence opl_seq_rowguid. Stored procedures "<name>_R_proc" and "<name>_U_proc".

© 1992 - OpenLink Software. All rights reserved.

Making Technology Work for You®