|
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 MATERIALIZED VIEW
INDEX SYNONYM
INDEXTYPE TABLE
OPERATOR TRIGGER
PACKAGE TYPE
PACKAGE BODY TYPE BODY
PROCEDURE 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. |
