Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to check table size in oracle 9i

Re: how to check table size in oracle 9i

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Sat, 17 Jun 2006 02:56:21 GMT
Message-ID: <Xns97E4CAFB154F6ianalvistahotmailcom@70.169.32.36> 





"manish" <manishsharmaocp_at_gmail.com> wrote in news:1150512490.732340.18750
@c74g2000cwc.googlegroups.com:



> how to check table size in oracle 9i

> 

> PLz help

> 

> 




SELECT SUM(BYTES) FROM DBA_SEGMENTS WHERE SEGMENT_NAME = 'MY_TABLE';

Received on Fri Jun 16 2006 - 21:56:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US