Re: datapump export to pipe
From: Kurt Franke <Kurt-Franke_at_web.de>
Date: Mon, 12 Oct 2009 17:49:01 +0200
Message-Id: <1315710671_at_web.de>
>
> Thanks for the ideas.
>
> I thought I'd got it with the following sh script, but it looks like
> exppd closes and re-opens a dump file from time to time,.. or fuser
> is lying to me :-)
>
...
>
> I set the filesize = 64M which was the max extent size and created
> loads of small file for testing.
>
> But expdp failed because a file got gzipped before expdp had finished
> with it. I haven't included a file size check, only fuser as you can
> see above.
>
> Any other ideas? I was thinking about doing a cross-check in the
> database to see if the file write was complete, perhaps in expdp's
> control table, but haven't found where yet.
>
> Regards
> Tony
>
Date: Mon, 12 Oct 2009 17:49:01 +0200
Message-Id: <1315710671_at_web.de>
Tony,
>Hi All,
>
> Thanks for the ideas.
>
> I thought I'd got it with the following sh script, but it looks like
> exppd closes and re-opens a dump file from time to time,.. or fuser
> is lying to me :-)
>
...
>
> I set the filesize = 64M which was the max extent size and created
> loads of small file for testing.
>
> But expdp failed because a file got gzipped before expdp had finished
> with it. I haven't included a file size check, only fuser as you can
> see above.
>
> Any other ideas? I was thinking about doing a cross-check in the
> database to see if the file write was complete, perhaps in expdp's
> control table, but haven't found where yet.
>
> Regards
> Tony
>
it's just a thought:
may be only the first file ist reopened for updating because there resides something like a table of contents ?
in this case you could compressing all finished files but the first one unless the expdp has totally completed.
regards
kf
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 12 2009 - 10:49:01 CDT