RE: Determine dump file size

  • From: "Stephens, Chris" <chris_stephens@xxxxxxxxxxxx>
  • To: <veeeraman@xxxxxxxxx>
  • Date: Thu, 17 Jan 2008 15:52:54 -0600

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.

Other related posts: