Invalid View object after impdp
Hello, i have imported a schema in another database and i had 3 invalid views,, I tried to recompile using alter view ..compile, but still invalid.. anyone can help meß 11-OCT-18 11:11:20.448: ORA-39127: unexpected error from call to “SYS”.”DBMS_CUBE_EXP”.”SCHEMA_INFO_EXP” ORA-44002: invalid object name ORA-06512: at “SYS.DBMS_ASSERT”, line 383 ORA-06512: at “SYS.DBMS_METADATA”, line 10616 11-OCT-18 11:11:23.448: ORA-39082: Object type VIEW:”OTRSTEST”.”VIEW_TICKET” created with compilation warnings 11-OCT-18 11:11:23.448: ORA-39082: Object type VIEW:”OTRSTEST”.”VIEW_TICKET_ISS” created with compilation warnings 11-OCT-18 11:11:23.448: ORA-39082: Object type VIEW:”OTRSTEST”.”VIEW_LINK” created with compilation warnings
Views got invalid, if the dependent objects are not present in the database. Please make sure the dependent objects of the view are present in the database.
Regards
Admin