Re: 8i migration - full import or schema imports ?

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Mon, 15 Apr 2002 00:58:23 -0800
Message-ID: <F001.004443A3.20020415005823@fatcity.com>

Agreed. In particular an effective (although rather deceitful) strategy is to indicate that you will be doing an unload/reload (to obtain the necessary downtime committment from management) but then (a) do a migration and (b) take advantage of all those 8i features to reorg the data "in place" via 'alter table move' and 'alter index rebuild' et al.

In this way, you manage to do a migration as well as getting one of those precious few moments to do a reorg of your system

hth
connor

• Jared Still <jkstill_at_cybcon.com> wrote: >
  > That depends on the size of your database.
  >
  > If over 20 gig or so, you may want to do migration
  > rather than an import. Imports are rather slow,
  > even
  > when optimized.
  >
  > Jared
  >
  > On Sunday 14 April 2002 15:18, jaroszewski andrzej
  > wrote:
  > > We are planning to perform migration from 7.3.4 to
  > 8i. We are considering
  > > full import versus schema by schema imports.
  > > What is the better method and what are the cons
  > and pros.
  > >
  > > Thanks
  > > Andrew
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Jared Still
  > INET: jkstill_at_cybcon.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Apr 15 2002 - 03:58:23 CDT