SQL> select segment_name, segment_type, bytes/1024/1024 mb from user_segments where segment_name='SALES'; SEGMENT_NAME SEGMENT_TYPE MB ------------------------------ ------------------ ---------- SALES TABLE 47