Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-39082 using IMPDP

polo001Oct 10 2018 — edited Oct 22 2018

Dear all,

I have the following warning error when I want to import full my dump in my source database :

I have the same release on both databases (11.2.0.4)

IMPDP log :

.....

ORA-39082: Object type VIEW:"VIEW_NAME"."NAME" created with compilation warnings

ORA-39082: Object type VIEW:"VIEW_NAME"."NAME_2" created with compilation warnings

.....

I have try to recompile the view but it doesn't work :

SQL> alter view VIEW_NAME.NAME compile;

Warning: View altered with compilation errors.

SQL> show errors view VIEW_NAME.NAME

Errors for VIEW VIEW_NAME.NAME:

LINE/COL ERROR

-------- -----------------------------------------------------------------

0/0 ORA-04063: view "VIEW_NAME.NAME" has errors

This post has been answered by polo001 on Oct 12 2018

Jump to Answer

Added on Oct 10 2018

#general-database-discussions

11 comments

11,768 views