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

Term: USER_REPGENERATED

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

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 109 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?