Re: Migration

> 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?

Use exp/imp only for transporting the database structure, using rows=n. Then use insert /*+ APPEND */ over database links for transporting data itself.

Just copying over the files or using cross-platform transportable tablespace doesn't probably work even though HP & IBM Unix servers both use Big Endian byte order. (Btw, in 10g you can use RMAN to convert tablespaces datafiles to any supported platform specific format :)

> 2.. Witch is the time frame in a worst case for this (how many hours,
> days or weeks!!)?

If planned well and on proper hardware, I guess you can do it in one weekend. It is possible to reduce downtime even more, but in that case you have to take special measures, like logging DML, precopying read only data, rolling upgrades, etc..

The worst case can be weeks, but of course you should be doing a lot of migration testing (with full dataset if possible), to be sure in your downtime requirement first.

Tanel.

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