Refresh Materialized views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Refresh Materialized views

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    2

    Question

    Im using materialized views, and I have a question : How I can refresh a materialized view with the commit of the remote table ??

    I can refresh with a fixed time ( 5 min. for example), but I want to refresh my view every commit.

    Thank you.

  2. #2
    Join Date
    Oct 2000
    Posts
    449
    create materialized view <mv>
    refresh complete on commit
    enable query rewrite as
    select acctnum, sum(bytes) bytes, count(bytes) c_bytes, count(*) from table1 group by acctnum;

  3. #3
    Join Date
    Feb 2001
    Posts
    2
    This is my snapshot, but I cant define it because :

    ORA-12054: ON COMMIT refresh atribute for materialized view cant be created.

    CREATE SNAPSHOT developer.vw_centro2
    PCTFREE 10
    PCTUSED 40
    MAXTRANS 255
    TABLESPACE ts_medicamentos
    STORAGE (
    INITIAL 98304
    NEXT 65536
    PCTINCREASE 50
    MINEXTENTS 1
    MAXEXTENTS 121
    )
    PARALLEL (DEGREE DEFAULT)
    REFRESH FORCE ON COMMIT
    USING MASTER ROLLBACK SEGMENT RBS
    local ROLLBACK SEGMENT RBS5
    AS
    select c.CLAVECENTRO,c.CODCENTRO
    ,c.DESCRIPCION
    from centro c

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