Oracle® TimesTen In-Memory Database SQL Reference Release 11.2.1 Part Number E13070-03 |
|
|
View PDF |
The REPSBUBSCRIPTIONS registers each subscribing store that maintains a secondary copy of a replication element.
Columns
Column name | Type | Description |
---|---|---|
REPLICATION_NAME | TT_CHAR (31) NOT NULL | Name for a replication scheme. |
REPLICATION_OWNER | TT_CHAR (31) NOT NULL | The replication scheme's owner. |
ELEMENT_NAME | TT_CHAR(31) NOT NULL | The replication name for this element, logically distinct from the name of an underlying data store object. |
SUBSCRIBER_ID | TT_BIGINT NOT NULL | The TT_STORE_ID for a subscriber to this element. A subscriber may not subscribe more than once to a replication element in a replication scheme. |
RETURN_SERVICE | TT_CHAR (1) NOT NULL | Return service for this subscriber with respect to this replication element:
'C' - RETURN COMMIT 'R' - RETURN RECEIPT '\0' - No RETURN services '2' - RETURN TWOSAFE |
RETURN_BY_REQUEST | BINARY(1) NOT NULL | The type of return services for this element.
0 - RETURN services are provided unconditionally 1 - RETURN services are provided only BY REQUEST This field is ignored if RETURN_SERVICES = '\0'. |
PRIVILEGES | TT_CHAR (1) NOT NULL | Privileges for this subscriber with respect to this replication element:
'\0' - no special subscriber privileges |