Re: Materialized View Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 12 May 2006 23:20:10 +0200
Message-ID: <8vu962hs85v0jc64i2oqevvc9tgklq03kl@4ax.com>

On 12 May 2006 08:13:25 -0700, "amerar_at_iwc.net" <amerar_at_iwc.net> wrote:

>Maybe I am just confused.
>
>I query the data dictionary and see two entries, one is a materialized
>view, and the other a table. Perhaps the materialized view entry is
>just that, an entry. And, the data is actually kept in the created
>table, which is being listed when I query the data dictionary.........

Which could be easily verified using user|all|dba_segments

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri May 12 2006 - 16:20:10 CDT