Is it possible to use the refresh method Fast PCT on a Cube MV?
When I run dbms_mview.explain_mview on my Cube MV I get the following message for my fact table:
"no partition key or PMARKER in select list"
Also - when I run dbms_cube.build('CUBE_NAME','P',false,4,false,true,false) I get an error saying that FAST_PCT is not supported for my cube.
However, judging from the documentation I would say that this should be possible. Anyone who has had any success with this?
The only workaround I have found is to create a view on the fact table that only contains the rows from the changed partition and do a LOAD PRUNE on the cube.