RE: ** imp using multiple compressed exp dump files

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <ajoshi977@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 6 Aug 2009 14:35:22 -0400

For what its worth, when I used to do this, I would export to an
export_file, and the ksh script would then cat the export_file | rsh to
a destination_file (the pipe), (HP-UX 64bit).  Import would import the
destination_file, (the pipe).

Export needed to start first as I recall, then import can start, and
then they both ran simultaneiously.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of A Joshi
Sent: Thursday, August 06, 2009 1:53 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: ** imp using multiple compressed exp dump files

   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. 



Other related posts: