Database DataWarehousing (MOSC)

MOSC Banner

Orphan materialized views in DBA_OBJECTS.

edited May 20, 2013 10:58PM in Database DataWarehousing (MOSC) 5 commentsAnswered
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%';

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