Re: datapump export to pipe
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: Kurt-Franke@xxxxxx, Fmhabash <fmhabash@xxxxxxxxx>, tony.adolph.dba@xxxxxxxxx
- Date: Mon, 12 Oct 2009 09:06:02 -0700 (PDT)
Yes, as I mentoned earlier that first file is surely be issue as per my test
sometime back when I had to take 500G dump.
Sanjay
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
--
//www.freelists.org/webpage/oracle-l
________________________________
From: Kurt Franke <Kurt-Franke@xxxxxx>
To: Fmhabash <fmhabash@xxxxxxxxx>; tony.adolph.dba@xxxxxxxxx
Cc: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
Sent: Mon, October 12, 2009 11:49:01 AM
Subject: Re: datapump export to pipe
Other related posts:
- » datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- ~Jeff~
- » RE: datapump export to pipe- D'Hooge Freek
- » RE: datapump export to pipe- Riku Räsänen
- » Re: datapump export to pipe- Joey D'Antoni
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Guillermo Alan Bort
- » Re: datapump export to pipe- Guillermo Alan Bort
- » Re: datapump export to pipe- Christoph
- » RE: datapump export to pipe- Powell, Mark D
- » RE: datapump export to pipe- Adams, Matthew (GE Indust, ConsInd)
- » RE: datapump export to pipe- Jost,
- » Re: datapump export to pipe- Jared Still
- » RE: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Powell, Mark D
- » Re: datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » RE: datapump export to pipe- MacGregor, Ian A.
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Joey D'Antoni
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Adric Norris
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Dunbar, Norman
- » RE: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Dunbar, Norman
- » RE: datapump export to pipe- Mercadante, Thomas F (LABOR)
- » RE: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Robert Freeman
- » RE: datapump export to pipe- Mercadante, Thomas F (LABOR)