Re: Porting database across hardware platforms

"JohnO" <john.d.osborne_at_hp.com> wrote in message news:<6NWW8.5$Yq6.269354_at_news.cpqcorp.net>...
> Yes, it seemed like export and import of the database would be the simplest
> and safest solution. What about data marshalling issues, such as the
> "endian" of numerics? Does exporting on one platform create a generic data
> structure that can be imported on a completely different HW platform
> correctly?
>
> Thanks
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tdmmiukkrctftfv5upd6vhsntmqngojpc1_at_4ax.com...
> > On Tue, 09 Jul 2002 19:59:29 GMT, "JohnO" <john.d.osborne_at_hp.com>
> > wrote:
> >
> > >I need to develop a method of porting multiple Oracle databases from one
> > >hardware platform to another, minimizing development work and rework
> (e.g.,
> > >a tool that can port a database with any schema), and maximizing
> > >performance, as these databases can be terabytes in size. If this
> requires
> > >coding, okay, but I would appreciate recommendations on available tools,
> and
> > >any useful strategies.
> > >
> > >Thanks
> > >
> >
> > Your 'tools' are called 'exp' and 'imp'
> >
> > Regards
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address

I came across a document a while back about errors relating to "little endian" to "big endian" byte order when doing a VLDB migration from one platform to another on Oracle Metalink http://metalink.oracle.com.

I think it had to deal with using a 32 bit migration utility VS 64 bit migration utility. If you Export using a 32 bit migration utility then you *have* to use 32 bit migration utility to do the Import even though the target database is on 64 bit version. I think that was the resolution but in any case, search for the document on Metalink..(Sorry no DocID) which I believe describes in detail all the supported migration tracks between different Oracle versions i.e. 32 Bit --> 64 Bit etc.

HTH
//Rauf Sarwar Received on Thu Jul 11 2002 - 00:35:08 CEST