Re: datapump export to pipe

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: cruepprich@xxxxxxxxx, Jared Still <jkstill@xxxxxxxxx>
  • Date: Thu, 8 Oct 2009 11:33:41 -0700 (PDT)

Isn;t the Datapump load the final Table in the first file after the Export is 
completed. If the first file is moved, then it may be the issue. I think I 
tried sometime back and got the issue with the first file. 


From: Christoph <cruepprich@xxxxxxxxx>
To: Jared Still <jkstill@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Thu, October 8, 2009 12:41:45 PM
Subject: Re: datapump export to pipe

Thanks Jared! That's a great idea. I'll play with that.


On Thu, Oct 8, 2009 at 11:38 AM, Jared Still <jkstill@xxxxxxxxx> wrote:

monitoring the file with fuser would probably be a good idea. 
>Just because the file is not growing does not mean it isn't open.
>The expdp process could be stalled for some reason.
>Jared Still
>Certifiable Oracle DBA and Part Time Perl Evangelist
>Oracle Blog:
>Home Page: 
>On Thu, Oct 8, 2009 at 6:38 AM, Christoph <cruepprich@xxxxxxxxx> wrote:
>>i played around with this a little yesterday. Instead of using a pipe, i just 
>>used a shell script that monitors the datapump directory. Whenever a new file 
>>of a certain naming convention appears, the script monitors its size. Once it 
>>stops growing or reaches the size matching the export filesize parameter, it 
>>zips up the file and moves it to another directory.
>>Maybe this could be a workaround for your problem.

"Men do not quit playing because they grow old; they grow old because they quit 
- Justice Oliver Wendell Holmes


Other related posts: