Quick Search:
 The Oracle PL/SQL ALL_REPGENERATED Keyword      [Return To Index] Jump to:  


In Oracle PL/SQL, the ALL_REPGENERATED dictionary view maintains the objects which are generated to support replication in database.

The structure of the view is as 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

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org