Home » Developer & Programmer » Data Integration » Materialized view
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
Previous Topic: how to fetch data from relational database into cube in express language
Next Topic: Urgent :Can I use 8i database with 9i warehouse builder
Goto Forum:
  


Current Time: Thu Mar 28 19:41:38 CDT 2024