Re: ORA-39082 during import

From: DA Morgan <>
Date: Sun, 23 Sep 2007 10:17:24 -0700
Message-ID: <> 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:
> 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sun Sep 23 2007 - 19:17:24 CEST

Original text of this message