Re: Import question

From: Chuck <chuckh_at_softhome.net>
Date: 30 Jul 2003 13:03:04 GMT
Message-ID: <Xns93C85C126C67Echuckhsofthomenet@130.133.1.4>

Chuck <chuckh_at_softhome.net> wrote in
news:Xns93C85ABB3E77Achuckhsofthomenet_at_130.133.1.4:

> nilanjan_sarkar_at_hotmail.com (nilanjan) wrote in 
> news:6c8b1f5.0307291558.6dfcca82_at_posting.google.com:
> 

>> I am trying to import just one table from an export file which has
>> the entire schema with a lot of other stuff, and since the file is
>> big in size more than the OS limit, it has been compressed. But I am
>> running into an error trying to read from the unix pipe during
>> import. The import waits for a while and then reports unexpected
>> end-of-file.
>>
>> So here is what I am doing :
>>
>> mkfifo $DBEXPORT/temp_fifo_import
>> uncompress > $DBEXPORT/temp_fifo_import < $DBEXPORT/big_export.dmp.Z
>> & import user/pass tables=xyz file=$DBEXPORT/temp_fifo_import &
>>
>> Pl let me know if you have used any of these similar methods to
>> import and any resolution...

> 
> I have seen problems like this before using gzip on Solaris, but never
> using compress/uncompress.
> 
> With no extension on temp_fifo_import, Oracle will add ".dmp" but
> oracle will not.

That should read "Oracle will add .dmp but *unix* will not".

HTH Received on Wed Jul 30 2003 - 08:03:04 CDT