repsites.sql
--------------------------------------------------------------------------- -- Filename: repsites.sql -- Purpose: Lists all replication sites. -- Author: Chas. Dye (cdye@excitecorp.com) -- Date: 28-Jun-1996 --------------------------------------------------------------------------- column GNAME heading "Group" format a15 column DBLINK heading "DB-Link" format a20 column MASTERDEF heading "Master|Def|Site?" format a6 column MASTER heading "Master|Site?" format a6 column PROP_UPDATES heading "Update|Requests" format 999,999,999 column MY_DBLINK heading "Is|This|Database?" format a9 SELECT gname, dblink, decode(masterdef, 'Y', 'Yes', 'No') masterdef, decode(master, 'Y', 'Yes', 'No') master, prop_updates, decode(my_dblink, 'Y', 'Yes', 'No') my_dblink FROM dba_repsites ORDER BY gname ASC, masterdef DESC /
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.