RE: Materialized view logs

From: David <thump_at_cosmiccooler.org>
Date: Wed, 13 Oct 2004 12:01:35 -0700 (PDT)
Message-ID: <4735.64.37.153.21.1097694095.squirrel@www.cosmiccooler.org>

The first query returns no rows.
The second query does list one LOG OWNER and MASTER twice for each LOG. Thaks for the help.

-- 
..
David


> When performing these quereies please be connected as either internal or

> the sys user.

> select owner, name, master, last_refresh, error

> from dba_snapshots;

> select log_owner, master, current_snapshot

> from dba_snapshot_logs;


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 13 2004 - 13:57:09 CDT