ALL_REPOBJECT

Contains information about the objects in each replication group accessible to the current user. An object can belong to only one replication group. A replication group can span multiple schemas.

Related Views:

• DBA_REPOBJECT contains information about the objects in each replication group in the database.
• USER_REPOBJECT contains information about the objects owned by the current user in each replication group.

  Column	Datatype	NULL	Description
  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.