Upgrade database to 9i or recreate it?

[Joop Kaashoek]

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

[Burton Peltier]

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@yahoo.com> wrote in message
news:ed7af232.0307070941.768aef80@posting.google.c om...

> 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