Newbie for database Upgrade

[kpate]

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?

[davey23uk]

why not just run dbua?

[kpate]

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

[davey23uk]

so? you can do that after

[kpate]

I am trying to prevent another outage

[davey23uk]

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

[kpate]

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.

[dbtoo]

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.

[kpate]

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?

[davey23uk]

alter table move
create table as select

many ways