General Database Discussions

Hi all,

Please help me to learn how to work with materialized view on prebuilt table.

I created prebuilt table:

  CREATE TABLE "RATER"."TMP003"

   (   

        "ITEM_ID" NUMBER(10,0)

   ) ;

I created materialized view on prebuilt table:

CREATE MATERIALIZED VIEW "RATER"."TMP003" ("ITEM_ID")

ON PREBUILT TABLE

AS SELECT "COST_DETAIL_ITEMS"."ITEM_ID" "ITEM_ID" FROM "RATER"."COST_DETAIL_ITEMS"@EFLP2.EFLATBED.COM "COST_DETAIL_ITEMS";

I checked quantity of rows at original source object:

SELECT count(1) as cnt FROM "RATER"."COST_DETAIL_ITEMS"@EFLP2.EFLATBED.COM "COST_DETAIL_ITEMS";

cnt

-----

61047571

I checked quantity of rows at my result object:

select count(1) cnt from "RATER"."TMP003"

----------

I tried to refresh my result object:

exec DBMS_MVIEW.REFRESH('RATER.TMP003');

anonymous block completed

I checked quantity of rows at my result object after try to refresh:

select count(1) cnt from "RATER"."TMP003"

----------

Please help me to understand how to refresh my result object properly.

Thanks.