Re: Cross-Platform migration (10g)
From: Yong Huang <yong321_at_yahoo.com>
Date: Sun, 13 Dec 2009 07:28:47 -0800 (PST)
Message-ID: <697434.53225.qm_at_web80608.mail.mud.yahoo.com>
> I need to move a database from Windows to HP-UX. What are my options
> besides exp/imp (datapump)?
Date: Sun, 13 Dec 2009 07:28:47 -0800 (PST)
Message-ID: <697434.53225.qm_at_web80608.mail.mud.yahoo.com>
> I need to move a database from Windows to HP-UX. What are my options
> besides exp/imp (datapump)?
About data migration in general. There's one rarely mentioned benefit of export and import (traditional or data pump). If your database hosts many small applications one or a few schemas for each app, you may lower overall down time by using export and import one app at a time. The benefit is that the app team can tell you the best time for migration. Unless they're truly 24x7, they may not consider your down time as their down time at all.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 13 2009 - 09:28:47 CST