Re: table size

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/10/28
Message-ID: <718p99$gio@dfw-ixnews6.ix.netcom.com>#1/1

How come no one remember the old method now... to find out the number of blocks used by the tables, use the ROWID of each row:

select count(*) from
(select distinct(substr(rowid,1,8)) from table1);

you will get the number of oracle block used by the the whole table.

Winnie Liu
Certified DBA

Fei Sha wrote in message <714dvs$g93$1_at_venus.uvsq.fr>...
>Hi everyone,
> How to know the size of a table in Mb or number of blocks?
>Thank!
>
>Fei
>
>
>
Received on Wed Oct 28 1998 - 00:00:00 CST