Column name
|
Data type
|
Description
|
---|---|---|
ID
|
INTEGER
|
Subscription identifier
|
SUBSCRIPTION_NAME
|
WVARCHAR
|
Unique subscription name
|
CONNECTION_ID
|
INTEGER
|
Connection identifier. Refers to SYS_REPLICATION_CONNECTIONS, see SYS_REPLICATION_CONNECTIONS
|
PARTITION_NAME
|
WVARCHAR
|
Partition name
|
LOAD_METHOD
|
VARCHAR
|
Load method
|
LOAD_DIRECTION
|
VARCHAR
|
Direction of load
|
CONFLICT_RESOLUTION
|
VARCHAR
|
Conflict resolution (TARGET WINS, SOURCE WINS, IGNORE, ABORT SUBSCRIPTION, or ROLLBACK TRANSACTION)
|
STATUS
|
VARCHAR
|
Status of the subscription (INIT, LOAD, STOPPED, ERROR, or ACTIVE)
|
FLAGS
|
INTEGER
|
Internal field
|
LAST_CONNECTED
|
TIMESTAMP
|
Actual time that subscription connected
|