Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL ALL_REPGENERATED Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: ALL_REPGENERATED

Definition:
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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 215 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?