Quick Search:
 
 The Oracle PL/SQL ALL_REPSCHEMA Keyword      [Return To Index] Jump to:  

Term: ALL_REPSCHEMA

Definition:
In Oracle PL/SQL, ALL_REPSCHEMA dictionary view stores the N-way replication information.

The structure of the view is shown below.

SNAME [VARCHAR2(30)] - Schema name containing the replicating group
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
GNAME [VARCHAR2(30)] - Replication group name
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 |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org