Import using Pipe
Hi All,
I am using database version is 10.2.0.4 .
I need to perform import using .gz file. I dont have space in the filesystem to unzip the .gz file so I need to use the .gz file to perform the import.
I am thinking of using unix pipe feature to perform the import. Here is what i am doing
$ mknod imp_pipe p
$ gunzip MWPPROD_EXPDP_13Jan.dmp.gz imp_pipe &
$ nohup impdp dumpfile=imp_pipe logfile=imp_pipe.log parfile=TWP136_IMP.par &
the import fails with following error
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/backup/MWPPR0D_Backup_4refreshMWPUAT/imp_pipe.dmp" for read
I am using database version is 10.2.0.4 .
I need to perform import using .gz file. I dont have space in the filesystem to unzip the .gz file so I need to use the .gz file to perform the import.
I am thinking of using unix pipe feature to perform the import. Here is what i am doing
$ mknod imp_pipe p
$ gunzip MWPPROD_EXPDP_13Jan.dmp.gz imp_pipe &
$ nohup impdp dumpfile=imp_pipe logfile=imp_pipe.log parfile=TWP136_IMP.par &
the import fails with following error
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/backup/MWPPR0D_Backup_4refreshMWPUAT/imp_pipe.dmp" for read
0