Re: 10g datapump
Date: Tue, 14 Oct 2008 08:54:45 -0700 (PDT)
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?
Failing that, a home-grown solution might unvolve the Unix "fuser" command.
HTH -g Received on Tue Oct 14 2008 - 10:54:45 CDT