Re: exp DB -> Binary file size??
From: Holger Spangardt <Holger.Spangardt_at_web.de>
Date: Fri, 20 Aug 2004 21:33:15 +0200
Message-ID: <cg5jk4$jn5$03$1_at_news.t-online.com>
Date: Fri, 20 Aug 2004 21:33:15 +0200
Message-ID: <cg5jk4$jn5$03$1_at_news.t-online.com>
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 - 21:33:15 CEST