Oracle查看SYS_LOB*文件属于哪个表

查看SYS_LOB*文件属于哪个表

SELECT B.TABLE_NAME,
       B.COLUMN_NAME,
       A.SEGMENT_NAME,
       a.SEGMENT_TYPE,
       ROUND(SUM(A.BYTES / 1024 / 1024 / 1024), 2) G
  FROM DBA_SEGMENTS A
  LEFT JOIN DBA_LOBS B
    ON A.OWNER = B.OWNER
   AND A.SEGMENT_NAME = B.SEGMENT_NAME
 WHERE B.SEGMENT_NAME = 'SYS_LOB0021914268C00014$$'
  GROUP BY B.TABLE_NAME, B.COLUMN_NAME, A.SEGMENT_NAME,a.SEGMENT_TYPE;