Could 8i import 9i data? [message #136073] |
Mon, 05 September 2005 22:35 |
rushing
Messages: 135 Registered: January 2004 Location: Beijing,China
|
Senior Member |
|
|
There is a Expdat.dmp file which was export by Oracle 9i.
I want to import it into Oracle 8i.
Some error appears.
Could not?
|
|
|
Re: Could 8i import 9i data? [message #136097 is a reply to message #136073] |
Tue, 06 September 2005 01:43 |
sunil_v_mishra
Messages: 506 Registered: March 2005
|
Senior Member |
|
|
hi,
You can export data from 8i to 9i it means from lower version to higer version but when u try to imp data of higer version into lower version there is always problem coz the version of exp & imp utility differs. that which is in 9i and 8i.
Mab be you can check out some other thing... but most of time this is the case when we are not able to do exp and imp properly when version of oracle are not same...i.e from 9i (exp) to 8i.(imp).
..If I am not correct then please let me know
Regard & thanks
sunilkumar
|
|
|
Re: Could 8i import 9i data? [message #137001 is a reply to message #136073] |
Mon, 12 September 2005 13:42 |
shahz198
Messages: 8 Registered: September 2005 Location: Pakistan
|
Junior Member |
|
|
well i have some other idea for u. Well few days earlier i had a same problem to solve but i actually succeeded.
firstly u should be having a software that can covert the data in ur tables of Oracle 9i to *.txt file Means Text File.WEll then use SQL Loader to convert data back to ur Oracle 8i from Oracle 9i.
i hope this will work for u. for help contact me at
shahzaib198@hotmail.com
|
|
|
Re: Could 8i import 9i data? [message #137693 is a reply to message #136073] |
Fri, 16 September 2005 02:41 |
alexzeng
Messages: 133 Registered: August 2005 Location: alexzeng.wordpress.com
|
Senior Member |
|
|
You should use oraclei8i's exp program to dump the data from oracle9i, then you could use imp to load the dump file to Oracle8i WITHOUT ERROR.
Hope this helpful
Alex zeng
|
|
|