Newbie for database Upgrade

This is the first time I am involved in database upgrade process, so please help me if I miss any step..
Database upgrade from 9i to 10g rel2 same os ( windows)

Preparing to upgrade
-- run utlu102i.sql on 9i env. and check for erros/suggestion
-- gather stats
-- shutdown database
-- exp userid= full=y

Upgrade database
-- Install 10g software
-- made necessary changes to init.ora, create sysaux ...etc
-- import

Question

will this import system object from 9i?
also do I have to startup database after import with upgrade option?
also do I have to run catupgrd.sql?

why not just run dbua?

Because I have to recreate tablespace to alter SEGMENT SPACE MANAGEMENT from MANUAL TO AUTO

so? you can do that after

I am trying to prevent another outage

that doesnt make sense, upgrade using dbua and do your work - one outage

So u mean upgrade with DBUA and then exp and imp.

Still I won't to know what method others follow for their database upgrade.

Quote:

---

Originally Posted by kpate

Still I won't to know what method others follow for their database upgrade.

---

Most refer to the documentation when doing upgrades:

http://download.oracle.com/docs/cd/B...o.htm#sthref10


To Quote the Propaganda:

Note:

The DBUA is the recommended method for upgrading a database. Beginning with release 10.2, you can also use the DBUA to upgrade to a new patch release of Oracle 10g release 2.

Question to davey23uk

If I choose DBUA method to upgrade database.

How the tablespace can be altered to SEGMENT SPACE MANAGEMENT AUTO.

Is there anyway except exp/imp?

alter table move
create table as select

many ways

So far I have done this step, Please let me know if I miss anything

Create a new database 10g and include all the new feature which is req. ( like create sysaux and change some init.ora parameter)

exp from 9i ( exported only application schema)

imp to 10g

post upgrade task:

compare the data dic. objects( app. schema) between 9i and 10g.

check the status from dba_registry for various component installed.