Home » RDBMS Server » Server Utilities » exp user in oracle 8i and import it in oracle 10g (oracle 10g)
exp user in oracle 8i and import it in oracle 10g [message #363409] Sun, 07 December 2008 01:36 Go to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
Dear all

i have a userin oracle8i and i want to exp. it and imp. it in oracle 10g
please if any one gives me a hint or a notification to do such thing

Best regards
Re: exp user in oracle 8i and import it in oracle 10g [message #363410 is a reply to message #363409] Sun, 07 December 2008 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just do it: exp, imp.

Regards
Michel
Re: exp user in oracle 8i and import it in oracle 10g [message #363412 is a reply to message #363409] Sun, 07 December 2008 01:57 Go to previous messageGo to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
thanks for your replay
but sorry i mean a dmp file it has been exported in 8i can i imported in 10g?

waiting your advice

best regards
Re: exp user in oracle 8i and import it in oracle 10g [message #363413 is a reply to message #363412] Sun, 07 December 2008 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: exp user in oracle 8i and import it in oracle 10g [message #363418 is a reply to message #363412] Sun, 07 December 2008 04:54 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do the export using Oracle 8i's EXP utility version.
Import it into the 10g database using Oracle 10g's IMP version.

In other words: export using the lower (of source and target) database version's EXP, import using the target database version's IMP.
Previous Topic: Exporting from Access to Oracle
Next Topic: IMP-00017,IMP-00003 with ora-00959
Goto Forum:
  


Current Time: Thu Dec 08 18:48:44 CST 2016

Total time taken to generate the page: 0.05082 seconds