I've upgraded many 9i database to 10g. It's pretty straightforward. You can read the instructions here;

10g upgrade companion

https://metalink.oracle.com/metalink/plsql/f?p=130:14:6468867796894194333::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,466181.1,1,1,1,helvetica

or Doc #466181.1



_____________________


___________________
From: Gauri Thakar [oracledba-ezmlmshield-x551570.[Email address protected]
Sent: Monday, April 28, 2008 10:31 PM
To: LazyDBA Discussion
Subject: upgrade from 9i to 10g

Hi,

I am intern working on Oracle Database.

I need to upgrade 9i to 10g.

Please let me know if migration or upgradation works effectively?

Feedback or inputs from dba is appreciated. Is there a document that
would be helpful?

Thank you,
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