With Major version upgrades, I create a new database instance and import
a full export from the previous database instance, then reapply any
system-level grants and run UTLRP against the instance. In this, you
won't end up with a lot of baggage from the previous version (like RBS).

Best to perform a bit of cleanup before you export:

1. Get rid of statistics
2. Truncate TEMP tables
3. Reset any sequences (if possible)
4. Renumber any dbms_jobs to start job = 10 as Oracle 10g already owns
one job with job = 1 and if you have a job that also has job = 1, it
will not import
5. Drop any unused tablespaces
6. Unlock any required accounts

Well, you get the point, I hope.

HTH,
Stephen

Stephen Price
Oracle Database Administrator
Compusearch Software Systems, Inc.


-----Original Message-----
From: Gauri Thakar
[mailto:oracledba-ezmlmshield-x95507160.[Email address protected]
Sent: Tuesday, April 29, 2008 1:27 PM
To: LazyDBA Discussion
Subject: upgrade from 9.2.0.5.0 to 10g

Hi,

I am still confused for upgrade from 9.2.0.5.0 to 10g.

Migrating or upgrading the database - what is used normally?



http://www.oracle.com/technology/obe/obe10gdb/install/9i10g/9i10g.htm#o
<http://www.oracle.com/technology/obe/obe10gdb/install/9i10g/9i10g.htm#o
>



This link shows that prerequisite is to have 10g installed.



Even if I want to upgrade - do I still need to have 10g downloaded?



Sorry I am still confused....





Gauri

Oracle DBA - INTERN





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page