Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I get the table size?
Use USER/ALL/DBA_SEGMENTS to get the total space consumed by the table (i.e. sum of its extents).
Use DBMS_SPACE to determine how much of the table's space is actually being used to store data.
Regards
Adrian
-- Posted via http://dbforums.comReceived on Thu Aug 29 2002 - 07:15:26 CDT