| Ask : Upgrade Oracle 9i to Oracle 10G [message #277681] |
Wed, 31 October 2007 03:00  |
chrysonite
Messages: 7
Registered: October 2007
|
Junior Member |
|
|
Hi,
I am trying to upgrade the Oracle Database from 9i to 10G. I'm planning to use the DBUA tools to perform this. What happens to the index or views that I've created in Oracle 9i? Does it automaticly rebuild? If I have an applications that using Oracle 9i as their database, what is the effect of upgrading the Oracle database? Must I also modify the applications?
Thanks,
[Updated on: Wed, 31 October 2007 03:01] Report message to a moderator |
|
|
|
| Re: Ask : Upgrade Oracle 9i to Oracle 10G [message #277687 is a reply to message #277681] |
Wed, 31 October 2007 03:21  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: |
What happens to the index or views that I've created in Oracle 9i? Does it automaticly rebuild?
|
Nothing is done.
| Quote: |
If I have an applications that using Oracle 9i as their database, what is the effect of upgrading the Oracle database?
|
SQL execution may change
| Quote: |
Must I also modify the applications?
|
You have to deeply test them before.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
