Cause of object loss during database transfer using exp/IMP across platforms

Source: Internet
Author: User

Since I started to use Oracle, I often used exp/IMP commands, which had been plagued by a problem.

We have installed databases on three different platforms: SunOS, Linux, and windows.

However, objects are often lost during the import and export process. The trigger has been lost,ProgramPackage.

I have suspected the database version, operating system platform, and other reasons. I have also performed enumeration experiments, but none of them can find the rule.

However, as the execution succeeds and the number of failures increases, I slowly guess a possible cause:

Exp is actually three different binary programs on SunOS, Linux, and windows, and the source code is different. Likewise, IMP has the same difference.

Therefore, if you want to avoid similar import and export errors, you must use the corresponding exp and imp. This should be a safe method.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.