Materialized view error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Materialized view error

  1. #1
    Join Date
    Apr 2001
    Posts
    35
    I created an materialized view in Oracle817 as follows.

    CREATE SNAPSHOT "NEMIS"."MV_TEST"
    BUILD IMMEDIATE
    REFRESH COMPLETE USING LOCAL ROLLBACK SEGMENT "RBS_LARGE1"
    START WITH to_date('26-May-2001 01:07:25 PM','dd-Mon-yyyy HH:MI:SS AM')
    NEXT sysdate + 1
    AS
    SELECT RGSN_ID, DSTR_NR,
    ADR_STRT_NM, ADR_LAT_COORD, ADR_LONG_COORD,
    ADR_CITY_NM, ST_CD, ZIP_CD,
    BUSN_NM, APPLIED_DT, INITIATION_DT,
    LOSS_DT, place_cd
    FROM TESTSCHEMA.TESTTABLE@TESTDBLINK

    I can use this snapshot. However, it shows a compilation error as follows. Why am I getting this?

    13:04:56 SQL> execute dbms_refresh.refresh(mv_test);
    BEGIN dbms_refresh.refresh(mv_test); END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 28:
    PLS-00357: Table,View Or Sequence reference 'MV_TEST' not allowed in this
    context
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

  2. #2
    Join Date
    Apr 2001
    Posts
    47
    Hi ann1,

    Try this:

    execute dbms_mview.refresh('mv_test');

    (a mview name should be 'ed.)

    Regards,

Posting Permissions

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



Click Here to Expand Forum to Full Width