adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle Architecture
  2. Suggest New Category

What are the consideration at tehe migration of Oracle 9i
to 10G.

Question Posted / Shamshul

Answer Posted / Shamshul

Migration from Oracle 9i to 10G involves several considerations, including:

1. Compatibility: Ensure that your applications and data are compatible with Oracle 10G. This may involve upgrading or modifying existing software to work with the new version of Oracle.
2. Hardware requirements: Oracle 10G requires more powerful hardware than Oracle 9i, so you may need to upgrade your server or add additional resources to support the migration.
3. Database structure: Review your database structure and ensure that it is optimized for performance with Oracle 10G. This may involve reorganizing tables, indexes, and other database objects.
4. Data conversion: If you have data in non-Oracle formats, you will need to convert it to a format that can be imported into Oracle 10G.
5. Testing: Thoroughly test the migration process to ensure that it is working correctly and that there are no unexpected issues or data loss.
6. Backup and recovery: Ensure that you have a backup of your existing database and that you have a plan for recovering data in case something goes wrong during the migration.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category