In Oracle PL/SQL, ALL_REPPROP maintains the methods of operations on each replicated object at another master site. These operations can be an embedded process through a procedure or a direct operation on an object.
The structure of the view is as below.
SNAME [VARCHAR2(30)] - Schema name containing the replicating group
ONAME [VARCHAR2(30)] - Replicated object group name
TYPE [VARCHAR2(16)] - Object type [FUNCTION | PROCEDURE | INDEXTYPE | MATERIALIZED VIEW | OPERATOR | TABLE | PACKAGE | TYPE | PACKAGE BODY | TYPE BODY]
DBLINK [VARCHAR2(128)] - Target database for propagation
HOW [VARCHAR2(13)] - Method of propagation
PROPAGATE_COMMENT [VARCHAR2(80)] - User comments on propagation