Forum Stats

  • 3,769,695 Users
  • 2,253,009 Discussions
  • 7,875,155 Comments

Discussions

Mv not getting refresh by it's own and how to add logging in this

chandra_1986
chandra_1986 Member Posts: 285 Blue Ribbon

HI experts,



I created below MV it's not getting refresh by it's own, refresh interval given 1 minute.


Also please suggest how can I add into logging into this.

 Create Materialized view sim_job
    
       refresh complete start with (sysdate) next (sysdate+1/1440) with rowid as
    SELECT TIMESTAMP,
    
     SUM(fs_count) AS fs_count
    
    
FROM
  (SELECT TO_CHAR(TRUNC(A.TIMESTAMP), 'MM/DD/YY') AS TIMESTAMP,
    COUNT(UNIQUE A.JID)                         AS FS_COUNT
  FROM LAS_ACT_PROD A,
    LAS_LOGIN B
  WHERE A.ID             IN ('LAS020')
  AND B.ROLE             IN ('TS_SW_TCH','TS_SE_TCH','TS_W_TCH','TS_W_TCH')
  AND TRUNC(A.TIMESTAMP)       = TRUNC(SYSDATE-1)
  AND A.ID                 =B.ID
  AND TRUNC(B.LOGINTIME) = TRUNC(SYSDATE-1)
  GROUP BY B.ROLE,
    TO_CHAR(TRUNC(A.TIMESTAMP), 'MM/DD/YY')
  )
GROUP BY TIMESTAMP


Answers