0 Replies Latest reply: Dec 12, 2012 6:29 AM by 979482 RSS

    Fast PCT on Cube MV

    979482
      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