Re: O8 reorganization or O9 upgrade - which first?

Hi,

i assume you have only one box.

How do you want to do it?

Make several disaster friendly backups first.

Shutdown, Install Oracle 9.x, migrate database from 8.x to 9.x?

Shutdown, Export, re-install Oracle and database, import?

With two boxes, maybe one small but big data disk-sized.

Normal operation, import into test-system via database link.

Fresh install on main system, reimport via database-link.

I highly recommend switching to Oracle 10g.

i did im/export via database link of EOM. Works even with 100 GB+ of data, only thing is to keep an eye on your undo tablespace.

I will do second option soon for several production systems 8,1,7.4 to Oracle 10.1.0.3.

The brave one would do two instances 8 and 10 on the same box ;-)

regards,

Toni

PS: i'd do a complete fresh install of at least Oracle software and database.
There have been very bad erros with migrated instances.

In article <cghvpk$gds$1_at_ls219.htnet.hr>, Njofra <njofra10_at_hotmail.com> wrote:

> We are running SAP 4.6C with Oracle 8.1.7 with huge database (800GB)
>
> We have done some data archiving and relaease some space (150GB) which is
> now again almost filled.
> Soon we will archive more data and we would like to do data reorganization
> (db export/import).
> Also we should upgrade to Oracle 9 because of maintenance end (until
> December 2004).
>
> Which should we do first: REORG or UPGRADE?
>
>
Received on Wed Aug 25 2004 - 08:35:40 CDT