Re: Downgrade from 8.1.5 to 8.0.5

Perhaps it's better to try to upgrade to 8.1.6? It has been released for Sun SPARC Solaris, HP-UX, AIX, and True64 UNIX.

HTH. Finn

Christian Kaas <ckaas_at_odn.de> wrote in message news:387d9d80.25831473_at_businessnews.de.uu.net...
> >I've been asked to look at the impact of downgrading from 8.1.5 to 8.0.5
for
> >reasons that do not need explaining here....
> >
> >What is the best way of doing this, ensuring that obviously we keep all
of
> >our data and users intact ???
> I think best would be to export all schemas using the 8.0.5 export
> utility then reimport the dump into your 8.0.5 instance.
> >
> >I don't think that we've been using any of the latest features of 8.1.5
> >which may have caused us even more problems...
> >
> >The only areas of concern are : external procedures and dynaminc
SQL...can
> >anyone confirm that these have remained the same between the two
versions.
> >
> External procedures under 8.0.5 are diffenerent in that way that they
> are not so efficiently cached. each time you call an extproc a new net
> session is created when using 8.0.5.
>
> Dynamic sql in 8.0.5 is possible only using the DBMS_SQL system
> Package NO "EXECUTE IMMEDIATE" syntax !
>
> that's all
>
>
Received on Wed Jan 12 2000 - 15:32:36 CST