What are the consideration at tehe migration of Oracle 9i
to 10G.
- 1 Answers
- 3183 Views
- Baidu, I also Faced
- E-Mail Answers
Answer / 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 |
Can a Tablespace hold objects from different Schemes in Oracle?
What are disadvanteges of having raw devices ?
How will you swap objects into a different table space for an existing database?
What Does DBWR do?
How will you create multiple rollback segments in a database ?
How will you force database to use particular rollback segment?
How to find the current session sid
How to find the SGA Size
What constitute an ORACLE Instance?
How will you monitor the space allocation ?
What is an Oracle Data Dictionary?
what is ORACLE MEMORY STRUCTURES
Oracle General 
