Re: Materialized Views

"Scott Reynolds" <tclaw420_at_hotmail.com> schreef in bericht news:far13h$5pm$1_at_aioe.org...
> "Scott Reynolds" <tclaw420_at_hotmail.com> wrote in message
> news:far0od$4dg$1_at_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.
>

Well at least you saved yourself from the remark that you should upgrade to Oracle 11g... ;-)

Shakespeare Received on Mon Aug 27 2007 - 14:33:11 CDT