Re: Upgrade database to 9i or recreate it?

From: Burton Peltier <burttemp1REMOVE_THIS_at_bellsouth.net>
Date: Wed, 9 Jul 2003 00:48:54 -0500
Message-ID: <ISNOa.4393$K67.3235@fe04.atl2.webusenet.com>

Just my opinion ... (with flashbacks to the version 6 to 7 Migrate tool problems)...

We are planning on upgrading to 9i from 8.1.7 using a full export and then import to an empty database with pre-created tablespaces . At the same time, I will be changing to locally managed tablespaces from dictionary managed.

Unless you have a large database (hundreds of Gig), the export/import seems cleaner to me , especially if doing things like chaning tablespace extent management.

-- 

"Joop Kaashoek" <jkaashoek_at_yahoo.com> wrote in message
news:ed7af232.0307070941.768aef80_at_posting.google.com...


> We are upgrading Oracle to 9i, from 8.1.7. The options we have for

> upgrading the database are to upgrade it using the DataBase Upgrade

> Assistant (easiest way) or to create a new database, which takes

> longer. Are there disadvantages to upgrading? I heard that the

> resulting  performance might be less than optimal for instance...

>

> Aplogies if this is a duplicate question.

> Regards,

>

> Joop Kaashoek

Received on Wed Jul 09 2003 - 00:48:54 CDT