Re: table size

S_at_lut Jeon,

There's a table in the dictionnary named all_tables:

desc all_tables;

 Nom                  Non renseigné NULL? Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 TABLE_NAME                      NOT NULL VARCHAR2(30)
 TABLESPACE_NAME                 NOT NULL VARCHAR2(30)
 CLUSTER_NAME                             VARCHAR2(30)
 PCT_FREE                        NOT NULL NUMBER
 PCT_USED                        NOT NULL NUMBER
 INI_TRANS                       NOT NULL NUMBER
 MAX_TRANS                       NOT NULL NUMBER
 INITIAL_EXTENT                           NUMBER
 NEXT_EXTENT                              NUMBER
 MIN_EXTENTS                              NUMBER
 MAX_EXTENTS                              NUMBER
 PCT_INCREASE                             NUMBER
 BACKED_UP                                VARCHAR2(1)
 NUM_ROWS                                 NUMBER
 BLOCKS                                   NUMBER
 EMPTY_BLOCKS                             NUMBER
 AVG_SPACE                                NUMBER
 CHAIN_CNT                                NUMBER
 AVG_ROW_LEN                              NUMBER
 DEGREE                                   VARCHAR2(10)
 INSTANCES                                VARCHAR2(10)
 CACHE                                    VARCHAR2(5)

so you can select table_name, block
from all_tables
where owner='YOU';

Alexandre Mavel
amavel_at_partner.auchan.com

>Hi everyone,
> How to know the size of a table in Mb or number of blocks?
>Thank!
>
>Fei
>
>
>
Received on Tue Oct 27 1998 - 06:57:15 CST