| upgrade [message #290113] |
Thu, 27 December 2007 08:49  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
we have an oracle 9.2.0.10 on a windows server 2000, with a database named alfa in c:\ora9i as home directory;
we are planing to upgrade to oracle 10g R2
we installed the 10g server in c:\10g on the same windows 200 server
we are planing to use export import in order to upgrade
is it possible to create a database under 10g named also alfa and
import to it ?
we dont want to create a database with a different name , cause database name might be hard coded in the application
in case of yes: please how to do so
any suggestions are really welcomed
thanks
|
|
|
|
|
|
| Re: upgrade [message #290137 is a reply to message #290114] |
Thu, 27 December 2007 10:53  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Copy Pfile or Spfile to new ORACLE_HOME/dbs folder.
step1:
Set Oracle_Home and sid of 9i database.
Delete your existing service by ORADIM command as
C:\oradim - delete -sid sidname
Step2 :
Set You ORACLE_HOME as 10g
create the service as mentioned by FRANK.
You have other option as well.
Backup you database .
drop database.
create new database in 10g with same name and then import.
NOTE: Must try it on test 1st.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
