Re: data pump import question
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: JSweetser@xxxxxxxx
- Date: Fri, 10 Dec 2010 18:45:18 +0000
Hi Joe
Do these object types have an associated oid in the source? If so then
that's likely the issue, though I thought the error was different.
On 10 Dec 2010 16:32, "Sweetser, Joe" <JSweetser@xxxxxxxx> wrote:
Greetings all,
Oracle 10.2.0.2
RedHat Linux AS5 (kernel 2.6.18)
I have a job that uses data pump to export from production and import
into development. One schema always gets 3 errors like the following
when compiling 3 procedures.
ORA-39082: Object type ALTER_PROCEDURE:"<SCHEMA>"."<PROCEDURE_NAME>"
created with compilation warnings
Once the import is finished, I can simply recompile the 3 procs and all
is well. But I am trying to figure why they fail compilation during the
import. As best I can tell (which may not be so good), the similar
trait all 3 procedures have is that they use private synonyms in their
code. MoS 793609.1 says that synonyms are imported before tables but
that shouldn't be problem. To wit:
When the synonym is created it is valid even if the table for which is
created does not exist. If the table is created afterward, it will
become invalid.
And then:
The fact that the synonyms are invalid after import is not a problem as
they will be automatically validated when they will be next called.
Of course, the recompilation takes place technically before the import
is completed and I wonder if that's the issue.
I don't think this is bug 5581731 because my source database is not a
multibyte character set (nor is the target database for that matter).
This is simply a minor inconvenience but I am trying to figure it out.
Any/all ideas/tips/pointers are welcome.
Thanks,
-joe
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the
sender immediately by reply email and delete this message. Although ICAT
Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and
attachments for viruses, it does not guarantee that either are virus-free
and accepts no liability for any damage sustained as a result of viruses.
Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
