ORA-12034: on new materializee view
I have a table
I have create a materialized view log on this table made with: NOCACHE
NOPARALLEL
WITH ROWID
and I have a materialized view on that table woth there options:
NOCACHE
LOGGING
NOPARALLEL
REFRESH COMPLETE ON COMMIT
this are the step I made:
1)create materialized log
2) create materialized view
then I tried to update a record and I recivied the error:
ORA-12034:
ORA-12034: materialized view log on "mu_user"."mytable" younger than last refresh
So I execute the complete refresh on material<ied view:
alter materialized view My_materilized view complete refresh;
I got the same error.