Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

10g datapump

14 views
Skip to first unread message

Chuck

unread,
Oct 13, 2008, 4:40:32 PM10/13/08
to
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.

gazzag

unread,
Oct 14, 2008, 6:35:41 AM10/14/08
to

Any particular operating system and version? Actually, a proper
Oracle version might help too.

Chuck

unread,
Oct 14, 2008, 11:29:03 AM10/14/08
to

Oracle 10.2.0.3 on Solaris 10

gazzag

unread,
Oct 14, 2008, 11:54:45 AM10/14/08
to

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

Chuck

unread,
Oct 20, 2008, 5:24:28 PM10/20/08
to

That document mentions the compression option only on the 11g datapump
utility, when connected to an 11g database.

I tried both the fuser and lsof commands. It seems like the 10g expdp
closes files that it's not completely done with and reopens them later.
I've still yet to find a way to determine if expdp is really done with a
file and is not going to go back to it later. I suspect there might be a
query you could run against the master table for the export, but there's
no documentation on how that file is used.

0 new messages