GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Dec 12, 2012 4:29 AM by 979482
Fast PCT on Cube MV
Dec 12, 2012 4:29 AM
Currently Being Moderated
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.
Track in Communications
- 10 points
- 5 points