Database Utilities (MOSC)

MOSC Banner

impdp ora-39082 on 10.2.0.4

edited Jun 21, 2018 9:51AM in Database Utilities (MOSC) 7 commentsAnswered
Hi,All

I executed
"expdp usrname/passwd dumpfile=dumpname.dp logfile=imp.log"
then scp the dumpname.dp to another host then execute
"impdp usrname/passwd dumpfile=dumpname.dp logfile=imp.log"
there were some warnings below:


ORA-39082: Object type TRIGGER:"MMM"."TI_DI_TP_DEF" created with compilation warnings
ORA-39082: Object type TRIGGER:"MMM"."TU_AI_DEFINE" created with compilation warnings


Then I checked the triggers PL/SQL code:
(1) ":NEW" changed into ":EW"
(2) "sql_str"(a variable defined in trigger MMM"."TI_DI_TP_DEF") changed into "sql_sr"
(3) "END IF" changed into "ND IF"

I check the code in source database, it's all right...

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