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" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>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"
><[EMAIL PROTECTED]>
>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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
