Re: Materialized Views name

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 14 Jul 2004 18:29:17 -0700
Message-ID: <1089854975.731130@yasure>

darkeagle wrote:

> Hi,
> I have a question.
> Suppose we create many materialized view as this example:
> CREATE MATERIALIZED VIEW A [ ... ]
> CREATE MATERIALIZED VIEW B [ ... ]
> CREATE MATERIALIZED VIEW C [ ... ]
> Etc
>
> Exists a procedure that obtain a list of the names of all materialized view
> presents in the db?
> For this example the procedure output will be like this:
> A, B, C
>
> Thank you.

SELECT owner, mview_name
FROM dba_mviews;

Learn your data dictionary.

Daniel Morgan Received on Wed Jul 14 2004 - 20:29:17 CDT