topic Re: Oracle imp of remote compressed dump file. in Operating System - Linux

Oracle imp of remote compressed dump file.

Gulam Mohiuddin — Wed, 28 Dec 2005 10:25:06 GMT

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.

Re: Oracle imp of remote compressed dump file.

Ivan Ferreira — Wed, 28 Dec 2005 13:08:51 GMT

Why don't you share it via NFS?

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

Re: Oracle imp of remote compressed dump file.

Steven E. Protter — Wed, 28 Dec 2005 14:44:37 GMT

Shalom Gulam,

Its not going to work.

Oracle import does work nicely on NFS or Samba mounts.

Thats the way to go.

SEP