dear all,
A materialized view created with 'REFRESH ON DEMAND' is not getting refreshed in oracle database.
CREATE MATERIALIZED VIEW TEST_MV
TABLESPACE APPS_TS_TX_DATA
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 128K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
WITH PRIMARY KEY
AS
...................
....................
kindly, help to sort out this issue.
your help will be appreciated thanks in advance.
thanks & regards.
os:rhel 6
db:11.2.0.3
ebs:11.2.0.3