From: tb on
Hi,

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
From: Mladen Gogala on
On Sun, 20 Jun 2010 09:51:25 -0700, tb wrote:

> Hi,
>
> 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

That is strange. How are you doing expdp? Did you specify the "parallel"
clause? Have you tried pre-creating the structures and then doing the
DATA_ONLY export/import? As for the transportable tablespaces, that is
probably the fastest option. You will, however, need to convert the data
files.



--
http://mgogala.byethost5.com
From: John Hurley on
tb:

>   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.
From: Robert Klemme on
On 20.06.2010 22:33, John Hurley wrote:
> tb:
>
>> 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.
>
> 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.

That's what I'd attempt, too. I think there are also some constraints
on this IIRC charsets must match. Otherwise you get error messages that
are not really revealing.

Cheers

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
From: Noons on
tb wrote,on my timestamp of 21/06/2010 2:51 AM:

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

That must be indeed a very slooooow Solaris sparc system!
I regularly export 100GB with expdp in AIX in much less than 2 hours.
Admittedly: a lot less than 400k db objects. Around 75K.