MVIEW BETWEEN 11G AND READ ONLY 12C DATABASE GIVES ORA-04063
(Doc ID 2921055.1)
Last updated on MARCH 01, 2023
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
When a materialized view is created on the 220.127.116.11 database with the Base table on 12c Read
Only Database (e.g. Standby Database) it gives error ORA-04063:
SQL> create materialized view mv_dual as select * from dual@test_link;
create materialized view mv_dual as select * from dual@test_link
ERROR at line 1:
ORA-04063: table "SYS.DUAL" has errors
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