RE: Convert database from AIX to Windows

Sent from my Windows Phone
From: Norman Dunbar
Sent: 18/01/2012 20:05
To: oracle-l_at_freelists.org
Subject: Re: Convert database from AIX to Windows Evening,

> There is a proposal to consolidate all hardware platform and we are looking
> at converting the database from IBM/AIX to Windows. What would be the best
> method to do this? Datapump or Transportable tablespace? The database is
> about 120G with2 large tablespaces each about 50-60G. Any gotchas with this
> conversion?

Not having used datapump yet, I'd be thinking about TTs myself. I used them recently to copy over a few terabytes from HPUX PA-RISC to Linux x86-86. It worked, however:

The exporting database has to be at 10.2.0.4 (I think) or above to get the use of cross platform TTs.

Also, the exporting database must be Enterprise Edition. A Standard Edition can only import TTs.

Other than that, and mine was from 9.2.0.6 SE to 11.2.0.2 SE, it's quite simple.

9206SE->9206EE->10204 first, then did the TT stuff. A quick RMAN to convert the datafiles to Linux and the imported them. Just worked.

Much much quicker than exp/imp!

Got a few more to do on my current project when they get the storage sorted out.

have fun.

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l