Re: ORA-39082 during import
Date: Sun, 23 Sep 2007 10:17:24 -0700
> Here's one that I've not been able to resolve or find any other info
> 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
look at utlrp.sql in your $ORACLE_HOME/rdbms directory. Alternatively you can use the built-in DBMS_RECOMP package.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Sep 23 2007 - 19:17:24 CEST