Definition:
In Oracle, the USER_REPGENERATED dictionary view maintains the information about the objects which are owned by the current user and is generated to support replication in the database. The structure of the view is shown below.
SNAME [VARCHAR2(30)] - Schema name containing the generated object
ONAME [VARCHAR2(30)] - Generated object name
TYPE [VARCHAR2(12)] - Generated object type
BASE_SNAME [VARCHAR2(30)] - Object owner schema name
BASE_ONAME [VARCHAR2(30)] - Object name
BASE_TYPE [VARCHAR2(12)] - Object type
PACKAGE_PREFIX [VARCHAR2(30)] - Package prefix
PROCEDURE_PREFIX [VARCHAR2(30)] - Procedure prefix
DISTRIBUTED [VARCHAR2(1)] - Determines whether object is generated for each master or not
REASON [VARCHAR2(30)] - Reason of generating the object
