X-FeedAbuse: http://nntpfeed.proxad.net/ feeded by 88.191.60.17 Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!news.tele.dk!news.tele.dk!small.news.tele.dk!proxad.net!feeder1-2.proxad.net!nntpfeed.proxad.net!news.side3.eu!gegeweb.org!aioe.org!not-for-mail From: "Scott Reynolds" Newsgroups: comp.databases.oracle.server Subject: Re: Materialized Views Date: Sat, 25 Aug 2007 23:55:08 -0500 Organization: Aioe.org NNTP Server Lines: 22 Message-ID: References: NNTP-Posting-Host: pD4a+wNH+QA8GSVJf1eyLg.user.aioe.org X-Complaints-To: abuse@aioe.org X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-RFC2646: Format=Flowed; Response X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-Priority: 3 X-MSMail-Priority: Normal Xref: usenetserver.com comp.databases.oracle.server:433864 X-Received-Date: Sun, 26 Aug 2007 00:55:15 EDT (text.usenetserver.com) "Scott Reynolds" wrote in message news: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! > Upon further inspection it seems that my query tool was clipping the "QUERY" column in the DBA_MVIEWS table so that it didn't seem like there was a complete query that composed the view. Sorry for the dumb question but I'm glad I was able to figure it out myself.