Oracle-L: Re: Table Size

From: Goran V <goranv_at_edb.eps.co.yu>
Date: Thu, 16 Oct 2003 00:19:24 -0800
Message-ID: <F001.005D3469.20031016001924@fatcity.com>

select bytes
from dba_segments
where segment_name = 'your_table';

divide the result by 1024*1024*1024 and you'll get the size in GB

Original Message ----- From: Pillai, Rajesh To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 15, 2003 9:24 PM Subject: Table Size

Hi All,

Could somebody help me in finding the actual size of an oracle table in GB.

TIA,
Rajesh

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Goran V
INET: goranv_at_edb.eps.co.yu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Oct 16 2003 - 03:19:24 CDT