Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: MATERIALIZED VIEW FOR PIVOTING TABLE QUERY
OK... :) I didn't made a question..
is anyone on Earth made fast refreshable materialized view on "pivot
table", and how?
"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
news:d47pkv$2kt$2_at_news4.zwoll1.ov.home.nl...
> Tom wrote:
>> I NEED TO CREATE MATERIALIZED VIEW FOR PIVOTING TABLE QUERY ..
>>
>> REFRESH = FAST
>>
>> I CAN NOT CREATE IT BECAUSE QUERY IS "TOO COMPLEX".. IS IT??
>>
>> DOCUMENTATION SAYS THAT MAX AND MIN FUNCTION CAN'T BE USED IN QUERY FOR
>> MATERIALIZED VIEW (FAST REFRESHABLE)
>>
>
> DON'T shout!
>
> So? Perhaps the docco is right, then?
> What do you expect from us?
> --
> Regards,
> Frank van Bortel
Received on Thu Apr 21 2005 - 04:17:24 CDT
![]() |
![]() |