Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Unable to compile ENI_DBI_CO_NUM_MV Invalid Object.

edited Feb 9, 2013 9:11PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered
 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>
Tagged:

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