| Murali |
Posted: May 07, 2008 10:54:53 PM |
Total Post: 3
Joined: May, 2008
|
Hello Friends,
If I am migrating from 9i to 10g on two different servers 9i and 10g sid is different schema name is different how can the migration be done. Also the character set is different. Already a application is running on 10g so the sid,characterset cannot be changed. Pls let me know your views |
|
|
 Mohammed Taj |
| Posted: May 08, 2008 09:23:45 AM |  |
|
Total Post: 634
Joined: Jul, 2007
|
If everything is different then what you migrate?
|
|
|
|
|
| Murali |
| Posted: May 08, 2008 10:25:45 PM | |
|
Total Post: 3
Joined: May, 2008
|
due to infrastructure limitation. the existing 9i server has limited space and 10g server has huge database space availability. I would like to know whether it is possible and if yes how to go about it
|
|
|
|
|
| dbavinod |
| Posted: May 12, 2008 08:19:31 AM | |
|
Total Post: 81
Joined: Sep, 2006
|
Upgrading to Oracle Database 10g
************************************
Oracle Database 10 gprovides a fairly easy upgrade path for users of older Oracle
versions. The following versions can directly be upgraded to Oracle Database 10 g:
�� Oracle Database 8.0.6
�� Oracle Database 8.1.7
�� Oracle Database 9.0.1
�� Oracle Database 9.2
If your database version is not in the preceding list, then you must first upgrade to one of these versions, after which you can upgrade to Oracle Database 10 g.
Upgrading the Database
After you are at a supported upgrade level, you can upgrade to Oracle Database 10 gby
using any one of the following four upgrade options:
�� Use the Oracle Database Upgrade Assistant (DBUA).
�� Perform a manual upgrade
You can use imp/exp (Oracle�simport/export utilities), however, to move the migrated database data to other versions of Oracle.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
