Home » RDBMS Server » Server Utilities » How to migrate from Oracle 8i to Oracle 10g with 100GB Data?
How to migrate from Oracle 8i to Oracle 10g with 100GB Data? [message #261528] Wed, 22 August 2007 23:41 Go to next message
jp7234
Messages: 2
Registered: August 2007
Location: Japan
Junior Member
Hi, everyone. Thank you in advance!

Now we are ready to migrate datum with the volume 100GB from Oracle 8i to Oracle 10g. We want to migrate the datum with the tool IMP/EMP. However , there may be many problems, fox examples:
(1) The migrating process will take many hours, maybe 50 hours and more....
(2) In the migrating process, if some error will happen, we have to migrate all of the datum again. That is to say, if some error happens, we have to restart the migrating process from the beginning.

How can I do for the migrating with so large volume 100GB? Please give me some advice. Thank you very much again.
Re: How to migrate from Oracle 8i to Oracle 10g with 100GB Data? [message #261529 is a reply to message #261528] Wed, 22 August 2007 23:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
see http://www.dbforums.com/showthread.php?t=1621758
Re: How to migrate from Oracle 8i to Oracle 10g with 100GB Data? [message #261534 is a reply to message #261529] Thu, 23 August 2007 00:03 Go to previous message
jp7234
Messages: 2
Registered: August 2007
Location: Japan
Junior Member
Thank you, please give me some information in details!
Previous Topic: Trasporting data between servers
Next Topic: How to close sql loader?
Goto Forum:
  


Current Time: Wed Dec 25 09:38:44 CST 2024