Re: Refresh groups

From: Brett Neumeier <random_at_interaccess.com>
Date: 1998/02/18
Message-ID: <6cfs9t$chc$1@nntp3.interaccess.com>#1/1

Michael Chambers (michael.chambers_at_vf.vodafone.co.uk) wrote:
: I have a refresh group on my database which should contain several
: snapshots. Given the name of the refresh group, how can I check what
: snapshots it currently contains? If I need to know the refresh group
: ID, how can I find this?

select rowner, rname, owner, name, refgroup, implicit_destroy,

	job, to_char(next_date,'MM/DD/YYYY HH24:MI:SS') next_date,
	interval, broken

from dba_refresh_children
where rname != name
order by rowner, rname
/

This is the query I use for refresh groups; I suspect it will do all you need.

-- 
-bn
random_at_interaccess.com	(PGP 2.6.2 public key available on request)
"There is no .signature -- only ZUUL!"

Received on Wed Feb 18 1998 - 00:00:00 CST