ياريت يجماعة حد يفيدني في هذا الموضوع علي وجة السرعة

عايز اعمل
upgarde database from 9i to 10g


ياريت يجماعة

1-you must upgrade your oracle 9i database to patchset 8 (9.2.8)

2-install oracle 10g release 2 software
3-run database upgrade assistant from Oracle 10g R2 and choose the Oracle 9i (9.2.8) home to upgrade
4-follow steps in the database upgrade assistant
5-it will now be upgraded to Oracle 10g R2
6-compile any invalid objects inside your database.
7-now you can delete your oracle 9i software as it is not needed

applying patchset 9208 is not a must
rdbms have to be atleast 9204

http://download.oracle.com/docs/cd/B19306_...up.htm#i1007814
Table 2-1 Upgrade Paths

http://download.oracle.com/docs/cd/B19306_...38/upgrade.htm#
This chapter guides you through the process of upgrading a database to the new Oracle Database 10g release.

>always check/do the following before applying major changes to database

make sure no invalid objects before upgrade
make sure all components in dba_registry with status "valid" only
have a full backup of the database before upgrade