Materialized view refresh fails - m_row$$ column

We have materialized view having m_row$$ column earlier in prod, but after db refresh to lower env. the db link stopped working, which is fine, so we re-created db link in non prod with different name, hence need to re create the mview as well

while recreating mview at target database build immediate using index with rowid option and refresh fast on demand option it is not allowing the m_row$$ column in mview, as the column not exist in source base table whereas the same is present in mview log table at source side. Even though it is refreshing the mview without that m_row$$ column.

Now after somedays, it is giving below error, any idea why it is behaving like this. Please suggest.

Ora-12018 and ora -00904 m_row$$ invalid identifier

Regards,
Arun

--
http://www.freelists.org/webpage/oracle-l