Re: Determine dump file size
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 17 Jan 2008 13:48:33 -0800
Message-ID: <bf46380801171348j3e9a5f49qade1e571d86861ae@mail.gmail.com>
)
/
Date: Thu, 17 Jan 2008 13:48:33 -0800
Message-ID: <bf46380801171348j3e9a5f49qade1e571d86861ae@mail.gmail.com>
On Jan 17, 2008 11:27 AM, Ram Raman <veeeraman_at_gmail.com> wrote:
> 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.
>
>
This query seems to be a bit pessimistic on my test case, but is within 10%
select sum(bytes) bytes
from dba_segments
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