Oracle imp of remote compressed dump file.

[Gulam Mohiuddin]

Hi,

Due to no free space I have to do an import of a compressed export dump file stored at remote server.

ServerA: (Export file Stored here)
/export/prod9i/exp_prod.dmp.Z (file size 6GB)

ServerB: (Doing import here with following command)

$remsh ServerA "nohup uncompress < /export/prod9i/exp_prod.dmp.Z >" | dd "of=/home/ora9i/dbjob/refresh/imp_pipe.dmp" &

$imp system/abc123@test fromuser=aq touser=aq rows=Y file=imp_pipe.dmp log=imp.log ignore=Y grants=N indexes=N \
constraints=N buffer=209715200 commit=Y recordlength=65535 &

I have already configured the .rhosts file and remsh is working fine.


Is this on the fly uncompress command on the remote server is correct?



Thanks,

Gulam.

[Ivan Ferreira]

Why don't you share it via NFS?

Sometimes, the uncompress command cannot handle files more than 2 GB. Use gzip/bzip2 instead.

[Steven E. Protter]

Shalom Gulam,

Its not going to work.

Oracle import does work nicely on NFS or Samba mounts.

Thats the way to go.

SEP