Re: Upgrading from 8.0.3 to 8.0.5

Anurag wrote:
>
> Hi,
> How do i upgrade from oracle database version 8.0.3 to 8.0.5.
> The documentation is very confusing.
>
> I have already installed 8.0.5 version but my database was created on
> 8.0.3. Now I am not able to do an export. It says Invalid version or
> something like that.

It *sounds* like you installed the 8.0.5 software & switched the database to using it (on a UNIX box by editing oratab to point to the new $ORACLE_HOME) but did not upgrade the database This will work in that the later software is compatible with the earlier database -- but you really should finish ny upgrading the *database*. Usually this means executing some PL/SQL scripts against (including, but not limited to, catalog.sql & catproc.sql.) These scripts will upgrade the iunternal Data Dictionary & stored procedures, including the ones that export & impoirt use. Read the upgrade documentation -- usually you can upgrade the db using the installer or by executing the scripts in server manager.
--

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730