Database DataWarehousing (MOSC)

MOSC Banner

ORA-12008: error in materialized view refresh path ORA-43930: A query issued from a pre-12.2 databas

edited Jan 15, 2019 9:57PM in Database DataWarehousing (MOSC) 5 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center