OraFAQ Forum: Server Utilities » Migration Oracle 8i to 9.2.0.5 using exp/ imp (diff. machines)

Home » RDBMS Server » Server Utilities » Migration Oracle 8i to 9.2.0.5 using exp/ imp (diff. machines)

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

Migration Oracle 8i to 9.2.0.5 using exp/ imp (diff. machines) [message #113445]

Sun, 03 April 2005 10:54

Javar
Messages: 2
Registered: April 2005

Junior Member

Hello,

i have a question. can i use export/ import to migrate a oracle 8 database to a oracle 9 database?

Scenario:
i have a machine (w2k server) running oracle 8.1.0.7 database. the name of the db is "ora8" and i have a new machine (w3k server) running oracle 9.2.0.5 without any database.
now i want to export the whole "ora8" database and import it into the new machine (after the transfer, the old machine will be shut down for ever). does this work ? if yes, what ist the best way.

thanx for your answer.

Mario

Report message to a moderator

Re: Migration Oracle 8i to 9.2.0.5 using exp/ imp (diff. machines) [message #113446 is a reply to message #113445]

Sun, 03 April 2005 11:29

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Yes you can. For detailed instructions, read chapter 8 (Database Migration Using Export/Import) of the "Oracle9i Database Migration Release 2 (9.2)" Guide.

Best regards.

Frank

Report message to a moderator

Re: Migration Oracle 8i to 9.2.0.5 using exp/ imp (diff. machines) [message #113447 is a reply to message #113445]

Sun, 03 April 2005 11:58

Javar
Messages: 2
Registered: April 2005

Junior Member

than you for your fast answer. i`ve read the chapter 8 (Database Migration Using Export/Import). it says that i have to export the db (oracle Cool

then i should install oracle 9.2 and then i have to create an new db with all tabelspaces, users etc. is thies correct?
i have 30 tabelspaces an round about 250 users.

Report message to a moderator

Re: Migration Oracle 8i to 9.2.0.5 using exp/ imp (diff. machines) [message #113451 is a reply to message #113447]

Sun, 03 April 2005 13:50

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

It's not required: "Pre-create tablespaces, users, and tables in the target database to improve space usage by changing storage parameters."

However, I would recommend pre-createing at least the tablespaces to ensure optimal file placement for best I/O throughput.

Best regards.

Frank

Report message to a moderator

Previous Topic:	IMP-00038
Next Topic:	Importing dmp file from client machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 05:32:21 CDT 2024