From John.Hallas@btcellnet.net Wed, 19 Sep 2001 10:53:13 -0700 From: Hallas John Date: Wed, 19 Sep 2001 10:53:13 -0700 Subject: RE: export with filesize option, dump file size estimation Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: export with filesize option, dump file size estimation This came up a few weeks ago and as I recall there was no firm answer.   Suggestions included summing the bytes from dba_extents where owner != 'sys' 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)   John -----Original Message-----From: Chen, Bill [mailto:BChen@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. 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. **********************************************************************