Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Nothing works => Import using multiple compressed files ?!!
I've imported using +7Gb dump files without any issue related to file size.
My opinion is that the command:
$cat `echo $DUMPDIR/vald2000_NGE_1904_05162006_*.dmp.gz | sort` |gunzip > /VMP1/archive/ngepipe.dmp &
is 'piping' two commands before getting the input file for import; my command uses only output redirection, furthremore I'm not sure of how cat and echo are working against gz files, I use directly gunzip (or gzip -d) for opening those files. Have you tried with the procedure I explained?
Regards,
Alessandro
> Yes Alessandro . Thanks for your reply.
> I created the pipe and then only tried it as below.
>
> $mknod /VMP1/archive/ngepipe.dmp p
>
> $cat `echo $DUMPDIR/vald2000_NGE_1904_05162006_*.dmp.gz | sort` |
> gunzip > /VMP1/archive/ngepipe.dmp &
>
> $imp parfile=/VMP1/export/ngedumps/imp.par &
>
> But i got the error as said in my original mail. Any thoughts ?
>
> Regards,
> Prem
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat May 20 2006 - 03:01:39 CDT
![]() |
![]() |