Re: exp DB -> Binary file size??

qazmlp wrote:

Hi,

> The size of the Oracle Database that we have in our Solaris machine
> is:'N' GB. We want to use 'exp' utility to export this DB into a file.
> What will be the size of that binary file? Does Oracle provide some
> specification on this?

select sum(bytes/1024/1024) from user_segments where segment_type = 'TABLE';

should give you a good estimation in MB.

Hope this helps,

        Holger Received on Fri Aug 20 2004 - 14:33:15 CDT