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!

mark (AT) markhibberdandassociates (DOT) com wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org