Re: Query rewrite

From: Adrian Simpson <bulleid_at_ffoil.org.uk>
Date: Mon, 16 Jan 2006 20:30:44 +0000
Message-ID: <fbdIEnC0JAzDFwMu@ffoil.org.uk>

In message <e8O49TX+VCyDFwm4_at_ffoil.org.uk>, Adrian Simpson <bulleid_at_ffoil.org.uk> writes
>
>Oracle 10.1.0.3
>
>
>We are just starting to work with data warehousing, and are having some
>problems with query rewrite. I need several materialized views that
>have a raw data type. This appears to mean that query rewrite will not
>work (although I haven't yet found a reason why - does anyone have a
>reference).

I've now found a reference to say that RAWs are not allowed in MVs (although you can create one with a raw in it), but not why.

Adrian

-- 
To Reply :
replace "bulleid" with "adrian" - all mail to bulleid is rejected
Sorry for the rigmarole, If I want spam, I'll go to the shops
Every time someone says "I don't believe in trolls", another one dies.

Received on Mon Jan 16 2006 - 14:30:44 CST