db move from solaris to aix

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

john - 29 Sep 2005 01:27 GMT

hi!

i want to move oracle 9.2.0.5.0 from solaris 9 to AIX (which is brand
new).
size is 150 gigs no rac,no replication,no standby.

i feel if i go with exp/imp its gone take a huge time for exp and
space issues for holding the .dmp file (any idea how much will be the
size of the .dmp file for 150 gigs and estimating the time)

is there any other possible or do u think exp/imp is the good choice
to go ahead.

any exact procedure. step by step .

thanks

Reply to this Message

sybrandb@yahoo.com - 29 Sep 2005 09:04 GMT

As this is a platform swap, and RMAN backups are not yet
platform-agnostic, exp/imp is the only way to go.
The size of 150 G doesn't tell anything. You may have allocated 150G
and using only 10g.

Signature

Sybrand Bakker
Senior Oracle DBA

Reply to this Message

john - 29 Sep 2005 23:22 GMT

sybra...@yahoo.com wrote:

> As this is a platform swap, and RMAN backups are not yet
> platform-agnostic, exp/imp is the only way to go.
[quoted text clipped - 4 lines]
> Sybrand Bakker
> Senior Oracle DBA

The datafile size iam telling , They are of 150 gigs around 70
datafiles.
used % are of 89 for most of the tablespaces. Now what do you think.
Since the current db is on solaris 32 bit, I think it is difficult in
full exp due to export filesize issues and only option left out I feel
is schema level.

Am I correct?

Reply to this Message

Rauf Sarwar - 30 Sep 2005 10:29 GMT

> sybra...@yahoo.com wrote:
> > As this is a platform swap, and RMAN backups are not yet
[quoted text clipped - 14 lines]
>
> Am I correct?

You can split up the dump file into multiple files. exp help=y will
show you all the parameters. Look for filesize parameter.

http://tahiti.oracle.com points to online Oracle docs.

Regards
/Rauf

Reply to this Message