Re: creating a 9i database in 8.1 compatibility mode

Chris S wrote:

> Anyone tried this? Succeeded?
>
> I recently upgraded a server with numerous databases on it from 8i
> (8.1.7) to 9i. (actually did full exports, uninstalled/deleted oracle
> 8i, installed 9i, imported data). 5 out of 6 databases were fine.
> Just one database is giving me trouble with just one client - some
> older financial application.
>
> Bottom line is I can't get rid of that client immediately so I need to
> solve this quickly. I tried to modify the 'compatibility' parameter
> but ran into ora-00402 errors - basically, can't down-grade the
> compatibility once the database is built, since too many features are
> built into the database already. Fair enough, makes sense.

Hi!
Why don't you try to have different databases of different versions? Different versions should be installed into different ORACLE_HOME. It works, i had 3 different databases (8.0.6/8.0.6/8.1.6) on the same exactly box. You even haven't to deinstall old version...

• Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru, ICQ #19972198