April 1999
Intermediate to advanced
552 pages
15h 39m
English
--------------------------------------------------------------------------- -- Filename: propmode.sql -- Purpose: Lists all replication sites and propagation modes. -- Author: Chas. Dye (cdye@excitecorp.com) -- Date: 28-Jun-1996 --------------------------------------------------------------------------- column SNAME heading "Group" format a8 column DBLINK heading "DB-Link" format a20 column HOW heading "Prop|Mode" format 999,999,999 clear breaks break on dblink skip 1 SELECT distinct(l1.dblink) dblink, l2.sname, l2.how FROM dba_repprop l1, dba_repprop l2 WHERE l1.dblink = l2.dblink AND l2.how != 'NONE' / clear breaks