Re: How to find the size of the database

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 2 Nov 1999 07:28:50 +0100
Message-ID: <941524172.16411.0.pluto.d4ee154e@news.demon.nl>

select sum(bytes)/1024 K, sum(bytes)/(1024*1024) M from dba_data_files
for total allocated space
select sum(bytes)
from dba_segments

for total used space.

Hth,

--
Sybrand Bakker, Oracle DBA
<spokal_at_my-deja.com> wrote in message news:7vlt6r$9ne$1_at_nnrp1.deja.com...
> Hello,
>
> Is there a way to find the size of the database from export dmp
> file. Or there is any other way to find it.
>
> Suggestions are appreciated.
>
> Thanks.
>
> Sailesh.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 02 1999 - 00:28:50 CST