This looks good to me. Importing into new tablespace will put the file
map in front which isn't done when upgrading 8i to 9i directly.

-----Original Message-----
From: Mathews Ansamma
[mailto:oracledba-ezmlmshield-x72858696.[Email address protected]
Sent: Thursday, September 08, 2005 12:38 PM
To: LazyDBA Discussion
Subject: 8i to 9i upgrade by exort/import

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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page