Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table or MV

Re: Table or MV

From: franck <francois.bourdages_at_harfan.com>
Date: 16 Oct 2006 07:01:00 -0700
Message-ID: <1161007260.735255.40870@i3g2000cwc.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US