Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA 12034 materialized view log on "mview_name" younger than last refresh

jjkJan 13 2010 — edited Jan 13 2010

Hello everyone,
When I'm trying to refresh a mview (10g), I face below error:

ERROR at line 1:
ORA-12034: materialized view log on "TS"."TTL_BILL_AMOUNT" younger than last refresh
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 1

That says the view log is younger than last refresh.
But I don't know how .. ??? can anyone tell me that ...

thanks
Rossy.Rocs

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2010

Added on Jan 13 2010

#general-database-discussions

3 comments

5,603 views