Re: ** imp using multiple compressed exp dump files

  • From: Tony van Lingen <tony_vanlingen@xxxxxxxxxxxxxxxxxxxxx>
  • To: Oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 07 Aug 2009 11:43:17 +1000

If the files xa* are compressed and you cat them, would compress -c not throw an error? Why not use:


zcat xa* > split_pipe &

Also, when I last did something like this on a DG/UX system (long ago), the fifo seemed to have the same 2GB limit as normal files. Export > pipe > compress did not run into that problem, but uncompress > pipe > import did (oracle 7.3 at that time). I memory serves right, the compressed file was around the 2GB mark. Perhaps imp tries to scan the entire file before doing something, which would cause the buffer to grow out of bounds..

Cheers,
Tony

Around 7/08/2009 3:53 AM, A Joshi said:
Hi,
   I did a export using split pipe compressed. Now I am trying import using :
nohup cat xaa xab xac xad > split_pipe &
nohup uncompress –c split_pipe > i_pipe &
nohup imp file=i_pipe ..

but I am getting error
IMP-00009: abnormal end of export file
IMP-00000: Import terminated unsuccessfully

I created the pipes using mknod similar to export which had no problem terminated without warnings. Any idea what can be the problem. The data is too big to do it without split or compress. Thanks for help.


--
//www.freelists.org/webpage/oracle-l


Other related posts: