Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Nothing works => Import using multiple compressed files ?!!

Re: Nothing works => Import using multiple compressed files ?!!

From: Alessandro Vercelli <alever_at_libero.it>
Date: Sat, 20 May 2006 10:01:39 +0200
Message-Id: <IZK0YR$A9BB1620239909DDB504C71644A15D19@libero.it>


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-l
Received on Sat May 20 2006 - 03:01:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US