Re: Q: EXP from AIX and IMP in HP possible?

Hmm.. I too have done this on the *same* platform, but I have my doubts between platforms, and I've never heard Oracle say anything like this is supported. Still, anyone tried it? Does it actually work?

Steve Phelan.

Kevin Brand wrote:

> Actually, you can copy the datafiles themselves from one platform to
> another, skipping any local LVM headers. Use dd for raw on UNIX or just
> copy the files from the filesystem.
>
> Once you have all the files in the proper place, including copies of the
> controlfiles and redo logs, and assuming that you don't want to change file
> names or path names, its just like starting up after a cold backup.
>
> I use something like this from AIX to AIX, but it should also work from HP
> to AIX or vice-versa ( adjusting for the differing LVM methodologies from
> one to the other ).
>
> On the host where you want to create the copy database, execute:
>
> remsh host_where_db_lives 'dd if=/dev/raw_device bs=8192000 | gzip -5' |
> gzip -d |dd of=/dev/my_new_logical_device bs=8192000
>
> note: the quotes above are very important.
>
> This assumes you are trusted as oracle between these two hosts and that you
> have a sub 100Mbs LAN or are sending across a WAN. Otherwise, you may not
> want to filter everything through gzip.
>
> Be very careful with this because you can easily wipe out your "good"
> database. In fact, I wouldn't recommend doing this at all. You should go
> ahead and use exp/imp, as this is much easier.
>
> -Kevin
>
> --
>
> remove the x for an email reply
> katincic_at_access.net.au wrote in message <3711E049.9642E443_at_access.net.au>...
> >Hi Stefano,
> >
> >it is possible and it is the only way to transfer database from one
> platform to
> >another
> >(I mean Exp/Imp). Just be sure to ftp the dump file (from one machine to
> >another)
> >in binary mode.
> >Cheers,
> >
> >Maya
> >
> >Stefano Unternaehrer wrote:
> >
> >> Hi all.
> >> Is it possible to export a schema from a Oracle Database
> >> running on an AIX server and import the file on HP-UX,
> >> where the same Oracle RDBMS version is running?
> >> Something to do or to take care?
> >>
> >> PLEASE: also send me your reply as message.
> >> Thank you!
> >> Stefano
> >
Received on Wed Apr 14 1999 - 17:12:06 CDT