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:[EMAIL PROTECTED]]
Sent: 19 September 01 19:10
To: Multiple recipients of list ORACLE-L
Subject: export with filesize option, dump file size estimationany 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.
**********************************************************************