RE: Re: Migration

Hi Stephane,

The way you put it here would mean that the internal format of the tablespaces will be big/little-endian independant.

That would mean either an extra amount of overhead in the low level IO, or Oracle-specific arithmatic everywhere in the kernel. I doubt whether Oracle would do that. It might (will!) cause severe performance penalties.

A few weeks ago I had an interview with Chuck Rozwat. I asked him this specific question. He was quite convinced telling me that the transport mechanism (data pump?) performs the HW-dependent conversions whenever you transfer a tablespace from one platform to another. He told me also that the HW-dependant differences will remain in place, and it isn't possible to have a R/O tablespace opened simultaneously by instances running on different platforms. (Not even Windoze/Linux combined) So the binary incompatability will remain in place.

Alas, I haven't got a beta version, so I haven't been able to test it yet :(

Regards, Carel-Jan

At 06:54 10-11-03 -0800, you wrote:
>It raises an interesting question. As of today, we have datafiles which
>are OS dependent and _not_ binary compatible from one system to another.
>We upgrade to 10g and it will become magically binary compatible. Which
>means that the upgrade process will do more intimate things than updating
>some file header block, creating a couple of new tables in the data
>dictionary and recreating view.
>
>Has anybody tried to upgrade from 9.x to 10g yet, on some database of
>decent size ?
>
>SF
>
> >----- ------- Original Message ------- -----
> >From: "Yechiel Adar" <adar76_at_inter.net.il>
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >Sent: Mon, 10 Nov 2003 05:54:25
> >
> >Wait for 10g. They say that you could just copy the
> >datafiles and them plug
> >them in to he new database, even across platforms.
> >
> >Yechiel Adar
> >Mehish
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L"
> ><ORACLE-L_at_fatcity.com>
> >Sent: Monday, November 10, 2003 12:24 AM
> >
> >
> >> Hi List,
> >>
> >> Could someone please help me?
> >>
> >> Assumption situation - Platform migration of
> >Oracle DW on Oracle DB (data
> >> volume 3.5 TB) from HP-UX to IBM-AIX
> >>
> >> 1.. DB migration; it is correct to use
> >Export/Import technique/method in
> >> the above assumption?
> >> 2.. Witch is the time frame in a worst case
> >for this (how many hours,
> >> days or weeks!!)?
> >> 3.. It is possible to apply the mentioned
> >technique or some other (witch
> >> one?) in uptime, totally or partially?
> >> 4.. Witches are the main tasks to consider in a
> >planning schedule?
> >> 5.. Witches are the time frames associated to
> >these tasks?
> >> Thanks
> >> Arm>o Teles
> >>
> >>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Stephane Faroult
> INET: sfaroult_at_oriolecorp.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  INET: cjpengel.dbalert_at_xs4all.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).