Re: Determine dump file size

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: