My Oracle Support Banner

ORA-32401: materialized view log on "USERNAME"."TABLENAME" does not have new values (Doc ID 2975506.1)

Last updated on MAY 02, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 TEST Schema use for this testing

create table test.dept(
deptno number(2,0),
dname varchar2(14),
loc varchar2(13),
constraint pk_dept primary key (deptno)
);

create table test.emp(
empno number(4,0),
ename varchar2(10),
job varchar2(9),
mgr number(4,0),
hiredate date,
sal number(7,2),
comm number(7,2),
deptno number(2,0),
constraint pk_emp primary key (empno),
constraint fk_deptno foreign key (deptno) references test.dept (deptno)
);

create materialized view log on test.emp with rowid;
create materialized view log on test.dept with rowid;

create materialized view test.empdept_mv
refresh fast on commit
as
select e.rowid e_rowid
, d.rowid d_rowid
, e.empno
, e.ename
, d.deptno
, d.dname
from test.myemp e
, test.mydept d
where e.deptno = d.deptno
and d.deptno = 10
group by e.rowid
, d.rowid
, e.empno
, e.ename
, d.deptno
, d.dname 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 ;
and d.deptno = 10
*
ERROR at line 13:
ORA-32401: materialized view log on "TEST"."MYDEPT" does not have new values

Changes

No Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.