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