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:
FUNCTION
INDEX
INDEXTYPE
OPERATOR
PACKAGE
PACKAGE BODY
PROCEDURE
SNAPSHOT
SYNONYM
TABLE
TRIGGER
TYPE
TYPE BODY
VIEW
|
STATUS |
VARCHAR2(10) |
|
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, then Oracle updates its status to DROPPED before deleting the row from the ALL_REPOBJECT view. |
GENERATION_STATUS |
VARCHAR2(9) |
|
Specifies 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 replication group to which the object belongs. |
MIN_COMMUNICATION |
VARCHAR2(1) |
|
If Y then use minimum communication for an update.
If N then send all old and all new values for an update. |
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. |
NESTED_TABLE |
VARCHAR2(1) |
|
If Y then the replicated object is the storage table of a nested table.
If N then the replicated object is not a storage table. |