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. 

Sanjay


________________________________
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.

C


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: http://jkstill.blogspot.com
>Home Page: http://jaredstill.com 
>
>
>
>
>
>On Thu, Oct 8, 2009 at 6:38 AM, Christoph <cruepprich@xxxxxxxxx> wrote:
>
>Tony,
>>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.
>>
>>Christoph
>>
>


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2009