Link to home
Start Free TrialLog in
Avatar of westergardhcw
westergardhcw

asked on

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?
Avatar of barthdev
barthdev
Flag of Canada image

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.

https://www.experts-exchange.com/questions/20864061/Export-from-9i-Import-to-8i.html

Regards,
Barth
ASKER CERTIFIED SOLUTION
Avatar of baonguyen1
baonguyen1

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mjblake
mjblake

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