ORA-39082 during import

From: <mark_at_markhibberdandassociates.com>
Date: Fri, 21 Sep 2007 16:17:40 -0700
Message-ID: <1190416660.722107.137060_at_19g2000hsx.googlegroups.com>

[Quoted] Here's one that I've not been able to resolve or find any other info on:

I'm importing (using impdp on 10g) a full schema into another schema on the same server. All is fine except for two errors like this: ORA-39082: Object type ALTER_FUNCTION:"REG56_MON"."F_CRT_MULT_RTS_VW" created with compilation warnings

The problem seems to be that the functions reference Views and the Views are imported AFTER the functions. Has anyone else seen this, and if so do you have a solution? It's not a critical error, more of a warning, I realize, but we have an automated process (VB script) that runs this process and after the import completes, it parses the resulting import log file and sends out an error email because of the ORA- error, which is what we want.

I'd like to somehow re-order the sequence of the import so that the Functions are imported AFTER the Views. Possible?

I could also run the import twice, the first time EXCULDING Functions and then the second time INCLUDING only the Functions, but I'd rather find a cleaner solution, if this is indeed the problem causing the ORA-39082. Thanks! Received on Sat Sep 22 2007 - 01:17:40 CEST

Original text of this message