Re: Determine dump file size

The schema I am trying to export has 100,000+ tables. THis option seems to give the size for each table separately. It will be difficult to sum them up.

On 1/17/08, Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com> wrote:
>
> Of course, that's available for Data Pump export (expdp) only.
>
>
> *Paul Baumgartel*
> *CREDIT SUISSE*
> Information Technology
> Prime Services Databases Americas
> One Madison Avenue
> New York, NY 10010
> USA
> Phone 212.538.1143
> paul.baumgartel_at_credit-suisse.com
> www.credit-suisse.com
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Stephens, Chris
> *Sent:* Thursday, January 17, 2008 3:50 PM
> *To:* veeeraman_at_gmail.com; oracle-l
> *Subject:* RE: Determine dump file size
>
>
>
> *ESTIMATE_ONLY*
>
> Default: n
>
> Purpose
>
> Instructs Export to estimate the space that a job would consume, without
> actually performing the export operation.
>
> Syntax and Description
>
> ESTIMATE_ONLY={y | n}
>
>
>
> If ESTIMATE_ONLY=y, then Export estimates the space that would be
> consumed, but quits without actually performing the export operation.
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ram Raman
> *Sent:* Thursday, January 17, 2008 1:27 PM
> *To:* oracle-l
> *Subject:* Determine dump file size
>
>
>
> 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.
>
>
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which
> it is addressed and may contain information that is privileged,
> confidential and exempt from disclosure under applicable law. If the
> reader of this message is not the intended recipient or the employee or
> agent responsible for delivering this message to the intended recipient, you
> are hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
> ==============================================================================
> Please access the attached hyperlink for an important electronic communications disclaimer:
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> ==============================================================================
>
>

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