Re: move database from sparc to linux

>   i have to move a 10.2.0.3 database from solaris sparc to red hat
> linux. I see 4 possibilities
>
> 1. exp/imp
> 2. expdp/impdp
> 3. Transportable Tablespaces
> 4. Oracle Streams
>
> The first approach was expdp and was not succesful, because there are
> 400000 database objects in a 100GByte database.  When i'm using expdp
> there, is no progress after one hour. I think exp will take between 30
> and 35 hours. Any idea is welcome.
>
> regards
> thomas

I would expect ( with reasonable bandwidth between the systems ) that you could use a link and impdp and parallel and complete the process in 8 hours or less. Unless the IO characteristics of the new linux system really suck. Received on Sun Jun 20 2010 - 15:33:14 CDT