Solved

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

Posted on 2004-03-21
5
560 Views
Last Modified: 2013-12-11
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
Comment
Question by:westergardhcw
5 Comments
 
LVL 4

Expert Comment

by:barthdev
Comment Utility
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
 
LVL 8

Accepted Solution

by:
baonguyen1 earned 50 total points
Comment Utility
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
 
LVL 1

Expert Comment

by:mjblake
Comment Utility
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now