Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table or MV
klabu wrote:
> how to tell if a "table" is actually a Materialized View ?
select * from user_mviews where MVIEW_NAME = 'X'; Received on Mon Oct 16 2006 - 09:01:00 CDT