Re: Determine dump file size
Date: Thu, 17 Jan 2008 13:48:33 -0800
On Jan 17, 2008 11:27 AM, Ram Raman <veeeraman_at_gmail.com> wrote:
> 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.
This query seems to be a bit pessimistic on my test case, but is within 10%
select sum(bytes) bytes
where owner = 'OWNER'
and segment_type not in (
'CACHE', 'ROLLBACK', 'TYPE2', 'UNDO', 'INDEX'
The actual dump size is right about 5 gig.
The estimate from this script was 5.5 gig.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 17 2008 - 15:48:33 CST