This discussion is archived
0 Replies Latest reply: Dec 12, 2012 4:29 AM by 979482 RSS

Fast PCT on Cube MV

979482 Newbie
Currently Being Moderated
Hi,

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.

Regards /Magnus

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points