OraFAQ Forum: Server Utilities » export from oracle 8i to oracle 8.0.5

Home » RDBMS Server » Server Utilities » export from oracle 8i to oracle 8.0.5

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

export from oracle 8i to oracle 8.0.5 [message #72593]

Mon, 28 July 2003 09:08

ajay gupta
Messages: 13
Registered: July 2003

Junior Member

How can I export data from Oracle 8i to Oracle8 and then import it in 8.0.5 database.

Report message to a moderator

Re: export from oracle 8i to oracle 8.0.5 [message #72594 is a reply to message #72593]

Mon, 28 July 2003 09:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use the lowest version of exp to do the export 
and use the same lowest version of imp to do the import.
so in your case use exp from version 8 to export from 8i database and import into 805 or 8 database.
create tns entries in verion 8 server so that i can talk to all the other databases.

[b]

8i db -------(exp)--------->8.0---------(imp)---->805

Report message to a moderator

Re: export from oracle 8i to oracle 8.0.5 [message #72606 is a reply to message #72594]

Wed, 30 July 2003 04:52

ajay gupta
Messages: 13
Registered: July 2003

Junior Member

Thank you for your help Mahesh. Where can I get the Oracle 8 export binary?

Report message to a moderator

Previous Topic:	8.05 to 8i IMPORT INVALID OBJECTS
Next Topic:	Port 8080

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 11:41:17 CDT 2024