| Materialized view [message #93410] |
Wed, 08 December 2004 08:32 |
Lizeth Vazquez
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
Hi, I made a materialized view, but it doesn´t refresh. If a refresh it manually it works, but I want it refresh all days. Do I need to configure something in the DB?
CREATE MATERIALIZED VIEW R_CONTEOS
PCTFREE 10
PCTUSED 0
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64 K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT)
TABLESPACE PRUEBA
LOGGING
NOCACHE
NOPARALLEL
USING INDEX PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT)
REFRESH COMPLETE
ON DEMAND
START WITH TO_DATE('08-Dic-2004 11:20:01','dd-mon-yyyy hh24:mi:ss')
NEXT TO_DATE(substr(to_char(sysdate,'YYYYMMDDHH24:MI:SS'),1,8)||'11:'||'20:'||'01','YYYYMMDDHH24:MI:SS')
WITH ROWID
USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS
select i.periodo,i.crn, a.sede, i.CLAVE, i.NOMBRE_CURSO,count(*) alumnos
from v_alumnos a, v_inscripciones i
where a.pidm = i.pidm
group by i.periodo,i.crn, a.sede, i.CLAVE, i.NOMBRE_CURSO
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
