OraFAQ Forum: Server Utilities » Export Large Database from O7 to O8i!

Home » RDBMS Server » Server Utilities » Export Large Database from O7 to O8i!

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

Export Large Database from O7 to O8i! [message #69339]

Tue, 11 December 2001 07:11

Johnny N
Messages: 1
Registered: December 2001

Junior Member

Hi!

Currently in our company we are using version Oracle 7.1.6, but we changed it to version Oracle 8i to mach our system, as we have ipgraded it. Because of the data approximately we have a database of 150GB~200GB running 24 hours. May I ask how would I migrate the data from Oracle 7.1.6 to Oracle 8i in a non-stop system?

As the above mentioned, should I use Oracle's exp/imp or SQL Loader to run this task. If I use exp/imp or SQL Loader then what would be the disadvantages and advantages? What should I consider? Would there be other ways to run this task?

Thanks!

----------------------------------------------------------------------

Report message to a moderator

Re: Export Large Database from O7 to O8i! [message #69340 is a reply to message #69339]

Tue, 11 December 2001 11:16

Melissa
Messages: 65
Registered: January 2000

Member

You can try and use the Migration Assistant. We tried it when we went from 7.3.4 to 8.1.5 and it didn't work. We even had an Oracle consultant come in and he couldn't get it to work. We did export/import. Whatever you do, you will have downtime.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	migration exp/imp
Next Topic:	Re: OCP Exam Papers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 09:25:26 CDT 2025