Re: Import question

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 may be the problem. Try putting a .dmp on the end of the name of the pipe and see if that works. If it doesn't you might try uncompressing the file and using "split" to create multiple output files, then use cat to combine them and write them to a single pipe that imp can read.

Keep us posted. Received on Wed Jul 30 2003 - 07:55:10 CDT