Re: Re: Re: Migration

Well, I don't know about it's performance, but I think this conversion doesn't require any temporary space, because the byte values of some structures in blocks have to be swapped, and this a trivial operation.

I think it may still be faster, especially if we are dealing with huge amounts of data, swapping bytes in blocks is faster than reading and parsing data through buffer cache, transferring it over sqlnet and formatting + writing it back to datablocks...

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 10, 2003 6:14 PM

> Tanel,
>
> Any idea about speed and temporary storage requirements? Especially for
32G+ datafiles ;-) ?
> Wondering if it will really be useful in practice, compared to what is
available today. Well, it may do for simpler operations, but not necessarily faster.
>
> SF
>
> >----- ------- Original Message ------- -----
> >From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >Sent: Mon, 10 Nov 2003 07:49:26
> >
> >You can't just copy over the files with os commands
> >and hope that Oracle
> >will somehow recognize them.
> >You have to use RMANs new convert tablespace
> >command to do the byte order
> >conversion.
> >
> >Tanel.
> >
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L"
> ><ORACLE-L_at_fatcity.com>
> >Sent: Monday, November 10, 2003 4:54 PM
> >
> >
> >> 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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).