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

Term: USER_REPGENOBJECTS

Definition:
In Oracle, the USER_REPGENOBJECTS dictionary view maintains information about all the objects in the database which are generated for replication for the current user. The structure of the view is shown below.

SNAME [VARCHAR2(30)] - The name of the replicated schema.
ONAME [VARCHAR2(30)] - The name of the generated object.
TYPE [VARCHAR2(12)] - The type of the generated object, either PACKAGE, PACKAGE BODY, TRIGGER , or INTERNAL PACKAGE.
BASE_SNAME [VARCHAR2 (30)] - The base object owner.
BASE_ONAME [VARCHAR2(30)] - The object for which this object was generated.
BASE_TYPE [VARCHAR2(12)] - The type of the base object.
PACKAGE_PREFIX [VARCHAR2(30)] - The prefix for the package wrapper.
PROCEDURE_PREFIX [VARCHAR2(30)] - The procedure prefix for the package wrapper.
DISTRIBUTED [VARCHAR2(1)] - This column is obsolete.
REASON [VARCHAR2(30)] - The reason the object was generated.

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