Re: HOW TO MIGRATE 100 DBs from 8.1.7 to 9.2.05

Comments in-line.

AYEB Mounir via OracleMonster.com wrote:

> Hi,
>
> I have about 100 databases between 10Gbytes an 1.7Tbytes
> they was migrated from 7 to 8 with the migrate option of oracle and many of them still have blocs V7

What does that mean? "still have blocs V7"?

> My Question is :
> what is the best way to migrate to V9i and profit from all the advantages of this version by
> a) illiminating the blocs V8 an V7

Once again what does this mean?

> b) usting the LMT

Absolutely.

> c) using the optimizer of V9

Absolutely. And that means you need to read the concepts docs and understand it. Just "turning it on" and assuming it will make things better is a non-starter.

> d) changing the db_block_size to bigger ( now 2K, 4K or 8K)

The block size should be determined based on your hardware and operating system and has nothing to do with the Oracle version. Read the docs and discuss with your UNIX SA and storage admin.

> Which of the nexts is the best ?
> 1) use the migrate option and then make a reorg by moving segments to a temporary tablespace and then back to the first one
> 2) use export , create the DB on V9 and then import even for the very large db ( 1.7 Tbytes )
> 3) use SQL*LOADER , then create the Db on V9 and then SQL*LOADER
>
> Please suggest me the best

Upgrade in place. You really don't want to move 1.7TB anywhere.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)