RE: export with filesize option, dump file size estimation

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Wed, 19 Sep 2001 10:53:13 -0700
Message-ID: <F001.00392EDE.20010919104536@fatcity.com>

This
came up a few weeks ago and as I recall there was no firm answer.
<SPAN

class=634094117-19092001> 
<SPAN

class=634094117-19092001>Suggestions included summing the bytes from dba_extents where owner != 'sys' <SPAN
class=634094117-19092001>or guessing.
I
always work on a theory of about 20-25% of the space used (i.e sum of all  the datafiles minus sum from dba_free_space)  
<SPAN

class=634094117-19092001>John

  <FONT face="Times New Roman"
  size=2>-----Original Message-----From: Chen, Bill   [mailto:BChen_at_us.britannica.com]Sent: 19 September 01   19:10To: Multiple recipients of list ORACLE-LSubject:   export with filesize option, dump file size estimation   any idea on how to estimate the export dump   file size without doing an actual export (not even to /dev/null)?   the idea is to use filesize option of   export utility to export db to several files. <FONT   face="Times New Roman">i am aware of using pipe/split to do large export.   

  thanks, bill

---

This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium.

---

Received on Wed Sep 19 2001 - 12:53:13 CDT