Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013
    Posts
    20

    Question Unanswered: materialized view on prebuilt table - refresh

    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"
    CNT
    ----------
    0



    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"
    CNT
    ----------
    0



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

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •