How to check the single table size in oracle11g

By using this query we can able to find the table size by below mentioned table format
owner.tablename. Eg - hr.employees

query:


select segment_name,segment_type, sum(bytes/1024/1024/1024) GB
 from dba_segments
 where segment_name='&Your_Table_Name' 
group by segment_name,segment_type;

Popular posts from this blog

Error in starting the service (OracleMTSRecovery)

ORA-39000, ORA-39143 ORA- 31619 invalid dump file in datapump

ORA-00439: feature not enabled: Flashback Database