Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: MATERIALIZED VIEW FOR PIVOTING TABLE QUERY

Re: MATERIALIZED VIEW FOR PIVOTING TABLE QUERY

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 21 Apr 2005 10:56:31 +0200
Message-ID: <d47pkv$2kt$2@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 - 03:56:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US