DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: MVIEW on commit refresh condition

Threaded View

  1. #9
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    Unhappy

    SQL> CREATE MATERIALIZED VIEW vw_teste
    2 BUILD IMMEDIATE
    3 REFRESH FAST ON COMMIT
    4 as
    5 SELECT codigo, nome
    6 FROM marcio.teste@pd00
    7 ;
    SELECT codigo, nome
    *
    ERROR at line 5:
    ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

    SQL> CREATE MATERIALIZED VIEW vw_teste
    2 PCTFREE 0 TABLESPACE usr
    3 BUILD IMMEDIATE
    4 REFRESH COMPLETE ON DEMAND
    5 AS
    6 SELECT codigo, nome
    7 FROM marcio.teste@pd00
    8 ;

    Materialized view created.

    BUT do not refresh

    Last edited by marcio.68; 05-12-2003 at 12:53 PM.
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

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