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

Default Asked on October 12, 2018 in ORACLE.
Add Comment
1 Answer(s)

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

Newbie Answered on October 21, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.