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

Term: USER_REPPROP

Definition:
In Oracle, the USER_REPPROP maintains the methods of operations on each replicated object which is owned by the current user at another master site. These operations can be an embedded process through a procedure or a direct operation on an object. The structure of the view is shown below.

SNAME [VARCHAR2(30)] - Schema name containing the replicating group
ONAME [VARCHAR2(30)] - Replicated object group name
TYPE [VARCHAR2(16)] - Object type [FUNCTION | PROCEDURE | INDEXTYPE | MATERIALIZED VIEW | OPERATOR | TABLE | PACKAGE | TYPE | PACKAGE BODY | TYPE BODY]
DBLINK [VARCHAR2(128)] - Target database for propagation
HOW [VARCHAR2(13)] - Method of propagation
PROPAGATE_COMMENT [VARCHAR2(80)] - User comments on propagation

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