me too
Patrik
Thomas Kyte <tkyte_at_us.oracle.com> schrieb in im Newsbeitrag:
0ubj4sc3l786lkmnqlugjpgn30vtfq681f_at_4ax.com...
> A copy of this was sent to Tiago Montes <tiago_montes_at_hp.com>
> (if that email address didn't require changing)
> On Sat, 04 Dec 1999 20:33:06 +0000, you wrote:
>
> >
> >
> > Hello,
> >
> >
> > I've recently started to learn Oracle RDBMS and I've got long
> > time skills in unix system administration.
> >
> > I believe my question is probably in a FAQ or some document...
> > But I must confess I _did_ not find it anywhere. Here it goes:
> >
> > My main goal is to "migrate" a 32 bit Oracle 8.0.5 database
> > running under HP-UX/PA-RISC to Linux/i386 and vice-versa;
> > Eventually being able to describe a process between any two
> > different Operating Systems and/or CPU architectures (say:
> > AIX/RS6000 -> Solaris/SPARC, VMS/Alpha -> SCO/i386, whatever)
> > among the same Oracle release - 8.0.5.
> >
> > MAIN QUESION: Is the internal format of the datafiles,
> > controlfiles, logfiles binary portable
> > among such different architectures ?
>
> no
>
> > Or it bit/little-endian dependant ? Or
> > something else ?
> >
>
> yes
>
> > Assuming such portability issues were ok, I'd be able to
> > do an offline transfer of the bunch of files, readjust
> > the init<sid>, config<sid>, etc and be done with it.
> >
> > Unfortunatelly, my first test for such method was unsuccessfull
> > in mounting the database -> my controlfiles are not ok... *sigh*
> >
> > Before going into details, I'd just like to hear the answer to
> > my FAQ (it is a FAQ isn't it ?) and eventually readjust my
> > strategy.
> >
>
> export/import
>
> database links
>
> sqlplus copy
>
> dump and load.
>
> > Thanks in advance for any input.
> >
> > Regards,
> > ____________________________________________________________________
> > Tiago Montes (tmontes_at_mail.telepac.pt)
>
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to
Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June
21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation
Received on Wed Dec 01 1999 - 06:26:31 CST
