954,561 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Export from 10 G 'n Import into 9i

hello all

My question is,

At, the server side i m using 10 G and at the client side i m using 9i when i use export utility then it create the dump file but when i try to import it then my command prompt doesnt show any progress of import the file and it is hanged can please tell me the reason why such kind of thing is happen when i m using different version of oracle any solution of this problem ???

john_beginner
Light Poster
42 posts since Mar 2009
Reputation Points: 9
Solved Threads: 0
 

One problem is the files produced by imp and exp are not backwardly compatible. That is if you use the 10g version of exp to create a dump file, you can't use the 9i version of imp to import the data.

In this case you need to use the 9i version of exp, connected to the 10g database, then use the 9i version of imp to import the data.

dan420
Newbie Poster
13 posts since Dec 2009
Reputation Points: 36
Solved Threads: 0
 

You need to use same version of EXP/IMP or EXPDP/IMPDP for database export and import.

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You