RE: Determine dump file size

From: William Wagman <>
Date: Fri, 18 Jan 2008 15:05:30 -0800
Message-ID: <>


There are a couple of bugs with the datapump incorrectly estimating space for tables with LOBS.Look at bug 5599947. It is still being worked and deals with slow datapump export using lobs. There is no patch available as work is still in progress. Look also at bug 6491831 RDBMS, DATA PUMP ESTIMATE NOT ACCURATE. I don't know if this is relevant to your case but I just encountered the problem.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208  

[] On Behalf Of Ram Raman Sent: Friday, January 18, 2008 12:14 PM
To: Oracle List
Subject: Re: Determine dump file size

Thanks all who replied.  

I was able to see the total estimated size using expdp in a small database, but it was hanging for over an hour for a DB of size ~200G. I had to kill it. Jared's script helped too.  

On 1/17/08, Tony Sequeira <> wrote:

	On Thu, 2008-01-17 at 13:27 -0600, Ram Raman wrote:

> Hi,
> Is there a way to determine the dump file size before the
> starts? I plan to do a full export of a database. ver 10.2.
> Thanks.
What I used to do back in the days of Oracle7. Unix or Unix tools required. Create a "named pipe" (mknod), pipe an export to this file, and wc -c the result. Have a google search. -- S. Anthony Sequeira ++ Smear the road with a runner!! ++ --
Received on Fri Jan 18 2008 - 17:05:30 CST

Original text of this message