Just want o clarify the steps from gurus.

I want to upgrade from 8i to 9i. Also doing a hardware upgrade. The 9i will
be residing in a new system.
This is how I see it should go.

1. Do a full export of the 8i database.

2. Install and create a new 9I database on the new system. It should have
the same name as the 8i DB.

3. Create all the tablespaces on the 9i system just like it was on the 8i
system.

4. Do an import into the 9i database.

Questions:

1. Are all these steps correct?
2. I have 2 instances of 8i I need to move over to the new 9i system. Is
there anything special I need to do?

Thanks in advance.

Regards,
Ancy

Oracle LazyDBA home page