Solved: Downgrade from Oracle 9i to 8i?

Create Account

Oracle Database

Questions

Followers

Top Experts

Ryan Chong🇸🇬

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.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

randyd

will you still have 9i on the box?

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

aleshm

randyd, can you provide with some url about "schedule for desupporting version 8"?

randyd

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

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Ryan Chong🇸🇬

ASKER

Hi randyd,

Can you provide me the exact url? i have problem finding it.

ASKER CERTIFIED SOLUTION

randyd

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

Ryan Chong🇸🇬

ASKER

Thanks for the comments, cheers

pjones4

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.

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Oracle Database

Questions

Followers

Top Experts

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.