-
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?
-
-
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.
-
 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|