Home » RDBMS Server » Backup & Recovery » Could 8i import 9i data?
Could 8i import 9i data? [message #136073] Mon, 05 September 2005 22:35 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: novell
Next Topic: rman duplicate produces multiple DB
Goto Forum:
  


Current Time: Thu Mar 28 16:10:57 CDT 2024