When checking a table's size in Oracle, we usually query dba_sgements. If a table contains large object columns like blob or clob data type, need to query dba_lobs as well. Below is the query I use quite often for such tables: SELECT sum( bytes)/1024/1024/1024 size_in_GB FROM dba_segments WHERE (segment_name = '&1' OR segment_name in ( … Continue reading Size of a table containing large object columns — clob & blob →