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
-- Install 10g software
-- made necessary changes to init.ora, create sysaux ...etc
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?
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.
Most refer to the documentation when doing upgrades:
Originally Posted by kpate
To Quote the Propaganda:
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
Click Here to Expand Forum to Full Width