Re: Oracle 8.1.7 32-Bit to Oracle 8.1.7 64-Bit

From: Eberhard Niendorf <eberhard.niendorf_schrott_at_t-online.de>
Date: Mon, 22 Nov 2004 18:40:01 +0100
Message-ID: <cnt89j$uor$05$1@news.t-online.com>

Bob wrote:

> Hi I would much appreciate help
>
> We have a 150-200GB database on Oracle 8.1.7 which resides on a HP-UX
> 32-bit machine. We are upgrading the HP-UX machine to 64-Bit.

Hi,

Do you want to upgrade Oracle-Software from 32bit to 64bit? On Solaris, I know 32bit Oracle-Software runs also on 64bit Solaris, but I don't know about HP-UX.
If you want or have to switch to Oracle 64 bit, then use can use the new 64bit oracle software on the "old" database, but you have to recompile all PL/SQL-procedures, no more. No exp/imp is necessary. - install 64bit Oracle-Software in a new $ORACLE_HOME - switch all environments to 64bit oracle and use it now - sqlplus "/ as sysdba" sql> startup restrict sql> @?/rdbms/admin/utlirp; sql> shutdown immediate sql> startup sql> @?/rdbms/admin/utlrp; sql> exit;

--> ready!

Eberhard Received on Mon Nov 22 2004 - 11:40:01 CST