Downgrade from Oracle 9i to 8i?
Let say the Oracle database is just served as a pure database backend (That's only for data saving purpose).
So, what's the possible problems that will occur when we downgrade from Oracle 9i to 8i? I afraid of this as i know that Oracle 9i is 'totally' different from Oracle 8i and previous version.
So i just want to confirm that is there any problems when i downgrade from Oracle 9i to 8i? What's the important things to take note?
And is this ok to migrate from a evaluation version of Oracle 8i to Oracle 8i stardand version?
Any good articles/links on explaining these are welcome as to support your view point.
Thank you.
So, what's the possible problems that will occur when we downgrade from Oracle 9i to 8i? I afraid of this as i know that Oracle 9i is 'totally' different from Oracle 8i and previous version.
So i just want to confirm that is there any problems when i downgrade from Oracle 9i to 8i? What's the important things to take note?
And is this ok to migrate from a evaluation version of Oracle 8i to Oracle 8i stardand version?
Any good articles/links on explaining these are welcome as to support your view point.
Thank you.
randyd, can you provide with some url about "schedule for desupporting version 8"?
the desupport lists by product and platform are on the metalink site:
http://metalink.oracle.com
under product lifecycle -> certifications under doc id 148054.1
Desupport end dates for 8.1.7 are:
ECS - Error Correction Support - 31-DEC-2003
EMS - Extended maintenance support - 31-DEC-2005
hth
randy
http://metalink.oracle.com
under product lifecycle -> certifications under doc id 148054.1
Desupport end dates for 8.1.7 are:
ECS - Error Correction Support - 31-DEC-2003
EMS - Extended maintenance support - 31-DEC-2005
hth
randy
ASKER
Hi randyd,
Can you provide me the exact url? i have problem finding it.
Can you provide me the exact url? i have problem finding it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the comments, cheers
We have several IBM RS/6000 workstations running various versions of Oracle. I happen to develop/maintain Pro*C/C++ code and found that executibles compiled with Oracle 9i's compiler core dumped when asked to run SELECTs against earlier versions of Oracle. The reason seems to be differences in the way that the result sets are handled in memory. DELETE, INSERT, UPDATE, etc., all worked fine. Just the SELECT had trouble.
If you have trouble running any C/C++ (or any other "external" language) programs that interact with Oracle after your transition, try recompiling again, but make sure that the compilers are the same as the version of Oracle you are connecting too.
- Pete J.
If you have trouble running any C/C++ (or any other "external" language) programs that interact with Oracle after your transition, try recompiling again, but make sure that the compilers are the same as the version of Oracle you are connecting too.
- Pete J.
the problems will occur when you do not entirely remove the 9i installation before you put the 8i version on. if you have a blank box, then put 8i on, then it is safer to put 9i on next and still get them both to run. (you should use 9.2 though as 9i is a bit buggy).
i guess you are aware that there is already a schedule for desupporting version 8, so i think it would be unwise to go that direction. if you are having bug issues, then move to 9.2 instead.
randy