Re: ORA-39082 during import

mark_at_markhibberdandassociates.com wrote:
> 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!

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.org