SNAME |
VARCHAR2(30) |
|
The name of the schema containing the replicated object. |
ONAME |
VARCHAR2(30) |
|
The name of the replicated object. |
TYPE |
VARCHAR2(16) |
|
The type of replicated object: table, view, package, package body, procedure, function, index, synonym, trigger, or snapshot. |
STATUS |
VARCHAR2(9) |
|
CREATE indicates that Oracle is applying user supplied or Oracle-generated DDL to the local database in an attempt to create the object locally. When a local replica exists, Oracle COMPAREs the replica with the master definition to ensure that they are consistent. When creation or comparison complete successfully, Oracle updates the status to VALID. Otherwise, it updates the status to ERROR. If you drop an object, Oracle updates its status to DROPPED before deleting the row from the ALL_REPOBJECT view. |
GENERATION_STATUS |
VARCHAR2(9) |
|
Whether the object needs to generate replication packages. |
ID |
NUMBER |
|
The identifier of the local database object, if one exists. |
OBJECT_COMMENT |
VARCHAR2(80) |
|
Any user supplied comments. |
GNAME |
VARCHAR2(30) |
|
The name of the replicated object group to which the object belongs. |
MIN_COMMUNICATION |
VARCHAR2(1) |
|
If Y then send only new values for an updated view.
If N then send both OLD and NEW values for an updated view. |
REPLICATION_TRIGGER_EXISTS |
VARCHAR2(1) |
|
If Y then internal replication trigger exists.
If N then internal replication trigger does not exist. |
INTERNAL_PACKAGE_EXISTS |
VARCHAR2(1) |
|
If Y then internal package exists.
If N then internal package does not exist. |
GROUP_OWNER |
VARCHAR2(30) |
|
Owner of the replication group. |