Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 575
  • Last Modified:

How to import from Oracle 9i R2 into Oracle 9i R1?

I have and export file from an Oracle 9i R2 database. The file was exported without errors. However, when I try to import the ".dmp" file into an Oracle 9i R1 database I receive numerous error messaages to include 922 and 945. Is there anyway to accomplish this important?
0
westergardhcw
Asked:
westergardhcw
1 Solution
 
barthdevSolution ArchitectCommented:
Hi westergardhcw,

It is safe to assume that you'll have a similiar experience for any Oracle version difference as is written about in this solution.

http://www.experts-exchange.com/Databases/Oracle/Product_Info/Q_20864061.html

Regards,
Barth
0
 
baonguyen1Commented:
westergardhcw, this rule is advised to apply if you want to export and import from/to different db version. You have to export using the lowest export utility involve the process, means 9i R1  in this case. IMport with the target import utility, 9iR1.

Hope this helps
0
 
mjblakeCommented:
I'd try using the 9iR2 tools for the import assuming that was used for the export.  Same suguestion as baonguyen1, just flipped around.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now