RE: Table Size

[Hsu, Anthony C., ,CPMS]

Try:

 

SELECT segment_type, segment_name,BLOCKS*8192/1024 "Kb"
        FROM   DBA_SEGMENTS
        WHERE  OWNER=UPPER('<owner>') AND SEGMENT_NAME = UPPER('<table_name>');

 

Tony
 

 -----Original Message-----
From: Pillai, Rajesh [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Table Size

Hi All,

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

 

TIA,

Rajesh