It gives a total size at the end. ...and you said 'full export.' That implies all schemas. From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ram Raman Sent: Thursday, January 17, 2008 3:44 PM To: paul.baumgartel@xxxxxxxxxxxxxxxxx Cc: oracle-l Subject: 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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx www.credit-suisse.com <http://www.credit-suisse.com/> ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> ] On Behalf Of Stephens, Chris Sent: Thursday, January 17, 2008 3:50 PM To: veeeraman@xxxxxxxxx; 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 ======================================================================== ====== 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.