Home » Other » General » Version Incompatibilities (V.8i and 10g)
icon4.gif  Version Incompatibilities (V.8i and 10g) [message #232353] Fri, 20 April 2007 04:25 Go to next message
txiki
Messages: 2
Registered: April 2007
Location: Barcelona
Junior Member
Hi all!!
first thanks for read my thread.
Then, I have a dubt, are there any incompatibilities with Oracle Verions 8i and 10g?

Anythink, at system level or pl/sql level, anythink.

Thanks/Danke/Gracias!!!
Re: Version Incompatibilities (V.8i and 10g) [message #232545 is a reply to message #232353] Sat, 21 April 2007 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you precise your question.
Do you want to know if you can install both version on a box?
The answer is yes but in different ORACLE_HOME.

Regards
Michel
icon4.gif  Re: Version Incompatibilities (V.8i and 10g) [message #232682 is a reply to message #232353] Mon, 23 April 2007 00:38 Go to previous messageGo to next message
txiki
Messages: 2
Registered: April 2007
Location: Barcelona
Junior Member
I have to install the oracl 10g database, and import data from 8i version DB, then, I have packages, procedures, triggers, and other pl/sql scripts, that's running on 8i, and now thows objects should be run on 10g.

It's a problem?
May appear any error about the version?

Re: Version Incompatibilities (V.8i and 10g) [message #232687 is a reply to message #232682] Mon, 23 April 2007 00:45 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All Oracle versions are backward compatible.
Code that works in 8i works in 10g (unless bug).
Some code may be improved using new features but this is another point.

Optimizer changes so SQL may encounter issues above all if you didn't previously use CBO but this is not PL/SQL.

Regards
Michel
Previous Topic: How to know???????
Next Topic: asset management system..
Goto Forum:
  


Current Time: Sat Apr 20 09:19:28 CDT 2024