Re: Determine dump file size
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: veeeraman@xxxxxxxxx
- Date: Thu, 17 Jan 2008 13:48:33 -0800
On Jan 17, 2008 11:27 AM, Ram Raman <veeeraman@xxxxxxxxx> 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
Other related posts:
