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

Term: USER_REPSITES

Definition:
In Oracle, the USER_REPSITES dictionary view displays all of the members that have access to the replication groups which are owned by the current user. The structure of the view is shown below.

GNAME [VARCHAR2(30)] - Replication group name
DBLINK [VARCHAR2(128)] - Target database for propagation
MASTERDEF [VARCHAR2(1)] - Determines whether the database is the master definition site for the replicated object group
SNAPMASTER [VARCHAR2(1)] - Determines whether the database is the current refresh master for the snapshot site
MASTER_COMMENT [VARCHAR2(80)] - User comments on the database site
MASTER [VARCHAR2(1)] - Determines whether the database is the master site for the replicated object group
GROUP_OWNER [VARCHAR2(30)] - Replication object group owner

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