Subscription metadata object v7

Suggest edits

After you add a subscription database definition, a single table named rrep_txset_health is created as the subscription metadata object.

For Oracle only: The RREP_TXSET_HEALTH table is created in the subscription database user’s schema as shown in the following output:

SQL> CONNECT subuser/password
Connected.
SQL> SET PAGESIZE 9999
SQL> SELECT table_name FROM user_tables ORDER BY table_name;

TABLE_NAME
------------------------------
RREP_TXSET_HEALTH

For SQL Server only: The rrep_txset_health table is created in the schema named _edb_replicator_sub.

1> USE subdb;
2> GO
Changed database context to 'subdb'.
1> SELECT s.name + '.' + o.name "Object Name", o.type_desc "Object Type"
2>   FROM sys.objects o,
3>        sys.schemas s
4>   WHERE s.name <> 'edb'
5>     AND o.type IN ('U','P','FN')
6>     AND o.schema_id = s.schema_id
7>   ORDER BY 2, 1;
8> GO
Object Name                            Object Type
-------------------------------------- --------------------------------------
_edb_replicator_sub.rrep_txset_health  USER_TABLE
(1 rows affected)

For Postgres only: The rrep_txset_health table is created in the schema named _edb_replicator_sub.

subdb=# SET search_path TO _edb_replicator_sub;
SET
subdb=# \dt
                     List of relations
       Schema        |       Name        | Type  |  Owner
---------------------+-------------------+-------+---------
 _edb_replicator_sub | rrep_txset_health | table | subuser
(1 row)

In all subscription database types (Oracle, SQL Server, and Postgres), when you remove the subscription database definitions using the Replication Server console or CLI, the subscription metadata object is deleted from the subscription database.

← Prev

Adding a subscription

↑ Up

Creating a subscription

Next →

On-demand replication