Re: 8.1.7.4 upgrade - 10g or 11

Peter, along with the CBO changes, there are other itmes that you must consider before upgrading to 10g such as datababase users with CONNECT role because there is no CONNECT role in 10g, timezones files are of higher version in 10g so if you storing data with TIMESTAMP WITH TIMEZONE then you will have to migrate the data carefully. In 10g dblinks store the encrypted passwords so you may need to recreate your dblink in 10g. If you read the upgrade guide, all this is documented properly.

I would suggest to upgrade to 10.2.0.3 and apply the latest patches advised in Critical Patch Advisory by Oracle.

Thanks & Regards

On 4/10/08, Schauss, Peter <peter.schauss_at_ngc.com> wrote:
>
> We are starting to plan an upgrade of one of our applications which
> currently runs on Oracle 8.1.7.4 on a Solaris server. The database is
> about 70 gb and I expect that the entire upgrade process will take
> between four and six months. The new version of the application will
> support either Oracle 10g or 11. Is 11g reliable enough that we should
> consider it instead of 10g?
>
> Will I be able to upgrade the 8.1.7.4 instance directly to the final
> version or will I need to do an intermediate upgrade?
>
> Thanks,
> Peter Schauss
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l