Mview Refresh Fails with "ORA-01740" and "PLS-00357: Table,View Or Sequence reference not allowed in this context" after failover
(Doc ID 2530481.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
After a failover from a standby to a primery database (ungraceful switch to the standby), you see errors like the following during an MV refresh:
A failover from a primary database to a standby database took place (ungraceful switch between the two database roles).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document