Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Location
    India
    Posts
    217

    Unanswered: Refreshing materialsed views

    I have a materialsed view as follows,

    Code:
    CREATE MATERIALIZED VIEW tab_vw
    BUILD IMMEDIATE
    REFRESH 
    START WITH sysdate NEXT sysdate+(1/(24*60))
    AS
    SELECT count(*) from tab where tname like 'RL%' 
    
    /
    The view is not getting refreshed every 1 minute.

    The materialzed view tab (under advanced replication ) shows ERROR for refresh state/compile state?

    Any suggestions?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Look on the server at the log files ... What do they tell you???
    BDUMP directory should have snp... text files that give you some idea.
    Post the bottom of one of those files and let's see what's going on.

    HTH
    Gregg

Posting Permissions

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