OraFAQ Forum: Server Utilities » exp user in oracle 8i and import it in oracle 10g

Home » RDBMS Server » Server Utilities » exp user in oracle 8i and import it in oracle 10g (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp user in oracle 8i and import it in oracle 10g [message #363409]

Sun, 07 December 2008 01:36

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

Report message to a moderator

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

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Just do it: exp, imp.

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

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

Littlefoot
Messages: 21808
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.

Report message to a moderator

Previous Topic:	Exporting from Access to Oracle
Next Topic:	IMP-00017,IMP-00003 with ora-00959

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 10:19:22 CDT 2024