Re: datapump export to pipe
Date: Thu, 8 Oct 2009 11:33:41 -0700 (PDT)
Message-ID: <275160.41442.qm_at_web51303.mail.re2.yahoo.com>
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_at_gmail.com> To: Jared Still <jkstill_at_gmail.com>
Cc: oracle-l_at_freelists.org
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_at_gmail.com> 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_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 08 2009 - 13:33:41 CDT