Arun Chugh
2018-09-03 17:35:49 UTC
All,
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
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