Re: 10g datapump

On 14 Oct, 16:29, Chuck <chuckh1958_nos..._at_gmail.com> wrote:
> gazzag wrote:
> > On 13 Oct, 21:40, Chuck <chuckh1958_nos..._at_gmail.com> wrote:
> >> When exporting to multiple files using options like filesize=100m and
> >> dumpfile=filename%U, is there a way to definitively know when oracle is
> >>  finished writing to a specific dump file?
>
> >> Here's why I ask. I need to compress the dump files, but don't want to
> >> wait until the entire job is finished before starting. I want to begin
> >> compressing files once I know oracle is finished with them, while it may
> >> still be writing to other files.
>
> > Any particular operating system and version?  Actually, a proper
> > Oracle version might help too.
>
> Oracle 10.2.0.3 on Solaris 10

As I understand it 10gR2 supports a COMPRESSION parameter with DataPump as well as a PARALLEL one. The functionality that you're trying to create might actually exist. Does this document help?

http://www.oracle.com/technology/products/database/utilities/pdf/datapump11g2007_quickstart.pdf

Failing that, a home-grown solution might unvolve the Unix "fuser" command.

HTH -g Received on Tue Oct 14 2008 - 10:54:45 CDT