Unable to compile ENI_DBI_CO_NUM_MV Invalid Object.
Hi Team,
select object_name,object_type,owner from dba_objects where status='INVALID' and object_name not in (select object_name from apps.invalid_3_33UM7XD);SQL> SQL> SQL>
OBJECT_NAME OBJECT_T OWNER
------------------------------ -------- ----------
ENI_DBI_CO_UNION_MV MATERIAL APPS
IZED VIE
SQL> alter MATERIALIZED VIEW apps.ENI_DBI_CO_NUM_MV compile;
Materialized view altered.
SQL> show error
No errors.
SQL>
OBJECT_NAME OBJECT_T OWNER
------------------------------ -------- ----------
ENI_DBI_CO_UNION_MV MATERIAL APPS
IZED VIE
SQL> alter MATERIALIZED VIEW apps.ENI_DBI_CO_NUM_MV compile;
Materialized view altered.
SQL> show error
No errors.
SQL>
Tagged:
0