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 <tony_at_sequeira.org.uk> 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 export
> > 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!!
> ++
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l