ORA-12008: error in materialized view refresh path ORA-43930: A query issued from a pre-12.2 databas
I have a view on a 12.1 Database and I have created remote materialized view on two other databases which were running on 12.1. I upgraded these remote databases to 12.2 but my source database continues to run on 12.1. Post this the materialized views stopped getting auto refreshed. I am getting the above error when I try to manually refresh the MVs.
I deleted and created the source view and the remote MVs and it worked for few days and stopped again giving the same error.
I then changed the compatible parameter to 12.1. Then again dropped and recreated the source view and remote MVs. It was working on both instances for few days but again stopped working on one.