how to get table size for partitioned table
878171Jul 26 2011 — edited Jul 26 2011Hi,
I've searched on various site and found a few scripts people posted.
1.This query doesn't give size of a partitioned table
select segment_name , tablespace_name, bytes/1024, blocks, extents
from user_segments
where segment_type='table'
2.found a script from Calros Romeu https://www.oraclespot.com, this is a good query as it gave total size, table, index and lobs, but didn't give partitioned table.
anyone know how and willing to share their script?
Thank you,
YOW