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 -> Materialized Views

Materialized Views

From: Scott Reynolds <tclaw420_at_hotmail.com>
Date: Sat, 25 Aug 2007 23:49:12 -0500
Message-ID: <far0od$4dg$1@aioe.org>


Hello everyone.

I an a newcomer to the forums and have a quick question of which I've been unable to find the answer in the documentation or online.

I am running Oracle 9i and wondered if there was a way to see the SQL select statement that comprises a particular materialized view? I have seen the DBA_MVIEW tables but I'm unsure as to how they relate to each other to create a SQL query to extract the information.

Thanks in advance for any and all help! Received on Sat Aug 25 2007 - 23:49:12 CDT

Original text of this message

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