Skip to Main Content

SQL & PL/SQL

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-12096: error in materialized view log

548849Jul 29 2009 — edited Jul 29 2009
Hi All,


I had created a fast refresh materialized view. Log was also created.

Now i dropped the mv and the logs.

But now every time i update or insert into this customer table i get error message.


ORA-12096: error in materialized view log on Customer
ORA-00942: table or view does not exist

There are entries in the DBA_MVIEW_LOGS for customer table.

Please suggest.
This post has been answered by Hoek on Jul 29 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2009
Added on Jul 29 2009
4 comments
15,127 views