Re: Help needed on moving data from 32-bit to 64-bit

What you do is to create the exact same directory structure in the new machine as in the existing machine.

Then check out where all the datafiles, controlfiles and logfiles of your old system are present. Copy them into the new machine in the same directory structure AFTER SHUTTING DOWN THE OLD DATABASE FIRST.

To save installation hassle, you could also create the oracle/dba user in the new system and copy the entire ORACLE_HOME (with subdirectories) into the new machine.

Startup and start using the new machine

Rgds,
Chetan
sriviswa_at_hotmail.com wrote in message <7s678l$2j9$1_at_nnrp1.deja.com>...
>Hi,
>
>Our development is on HP-UX 11 (32-bit) with
>Oracle 8.1.5. We will shortly be moving to
>production on a HP-UX11 (64-bit) platform. we
>discovered that Oracle still doesn't have a 8.1.5
>for 64-bit. So we put the available 8.0.5.1 on the
>64-bit box. Now, we wanted to port one of the
>existing databases from the 32-bit box over. Any
>suggestions how to do it? Export/ftp/Import blew
>me out (guess because of 32-bit and 64-bit). Are
>scripts the only way to do it? Thanks. (Note: I
>am a rookie DBA....a detailed answer would be
>appreciated)
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Sep 21 1999 - 07:01:07 CDT