Home » RDBMS Server » Server Administration » Ask : Upgrade Oracle 9i to Oracle 10G (Oracle 9i, 2, Windows)
Ask : Upgrade Oracle 9i to Oracle 10G [message #277681] Wed, 31 October 2007 03:00 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Version Compatibility
Next Topic: undo and temp tablespaces
Goto Forum:
  


Current Time: Tue Dec 06 10:20:41 CST 2016

Total time taken to generate the page: 0.11823 seconds