Orphan materialized views in DBA_OBJECTS.
RDBMS 11.2.0.3Microsoft Windows x64 (64-bit)
Orphan materialized views in DBA_OBJECTS.
there exists MV in dba_objects while they are dropped , i ran health check script and no issues and all components in dba_registry are valid.
Example:
SYSTEM@ELYXWEB> select mview_name from dba_mviews where owner='REF_DATA';
MVIEW_NAME
------------------------------
PCICAD_MJ2_PARCEL_MVUE
MJ2_PARC_PROP_MVUE
CAD_PARCELLE_MVUE
PCICAD_PARCELLE_MVUE
PCI_PARC_MVUE
PCICADMJ2_PARC_PROP_MVUE
MJ2_PARCELLE_COPRO_MVUE
7 ligne(s) sélectionnée(s).
SYSTEM@ELYXWEB> select object_name from dba_objects where owner='REF_DATA' and object_type like 'MATER%';
Orphan materialized views in DBA_OBJECTS.
there exists MV in dba_objects while they are dropped , i ran health check script and no issues and all components in dba_registry are valid.
Example:
SYSTEM@ELYXWEB> select mview_name from dba_mviews where owner='REF_DATA';
MVIEW_NAME
------------------------------
PCICAD_MJ2_PARCEL_MVUE
MJ2_PARC_PROP_MVUE
CAD_PARCELLE_MVUE
PCICAD_PARCELLE_MVUE
PCI_PARC_MVUE
PCICADMJ2_PARC_PROP_MVUE
MJ2_PARCELLE_COPRO_MVUE
7 ligne(s) sélectionnée(s).
SYSTEM@ELYXWEB> select object_name from dba_objects where owner='REF_DATA' and object_type like 'MATER%';
0