Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
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 6:29 AM by
Fast PCT on Cube MV
Dec 12, 2012 6:29 AM
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.
This content has been marked as final.
Show 0 replies