April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- 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
/