Re: datapump export to pipe

From: Sanjay Mishra <smishra_97_at_yahoo.com>
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-l
Received on Thu Oct 08 2009 - 13:33:41 CDT

Original text of this message