select
  e.inst_id,                               -- INST_ID NUMBER
  ds.owner,                                -- OWNER VARCHAR2(30)
  ds.segment_name,                         -- SEGMENT_NAME VARCHAR2(81)
  ds.partition_name,                       -- PARTITION_NAME VARCHAR2(30)
  ds.segment_type,                         -- SEGMENT_TYPE VARCHAR2(18)
  ds.tablespace_name,                      -- TABLESPACE_NAME VARCHAR2(30)
  e.ext#,                                  -- EXTENT_ID NUMBER
  f.file#,                                 -- FILE_ID NUMBER
  e.block#,                                -- BLOCK_ID NUMBER
  e.length * ds.blocksize,                 -- BYTES NUMBER
  e.length,                                -- BLOCKS NUMBER
  e.file#                                  -- RELATIVE_FNO NUMBER
from
  x$logmnr_uet$ e,
  v$logmnr_sys_dba_segs ds,
  x$logmnr_file$ f
where
  e.segfile# = ds.relative_fno and e.segblock# = ds.header_block and e.ts# = ds.tablespace_id and ds.tablespace_id = f.ts# and e.file# = f.relfile# and bitand(NVL(ds.segment_flags,0), 1) = 0 and bitand(NVL(ds.segment_flags,0), 65536) = 0
union all
select
  e.inst_id,                               -- INST_ID NUMBER
  ds.owner,                                -- OWNER VARCHAR2(30)
  ds.segment_name,                         -- SEGMENT_NAME VARCHAR2(81)
  ds.partition_name,                       -- PARTITION_NAME VARCHAR2(30)
  ds.segment_type,                         -- SEGMENT_TYPE VARCHAR2(18)
  ds.tablespace_name,                      -- TABLESPACE_NAME VARCHAR2(30)
  e.ktfbueextno,                           -- EXTENT_ID NUMBER
  f.file#,                                 -- FILE_ID NUMBER
  e.ktfbuebno,                             -- BLOCK_ID NUMBER
  e.ktfbueblks * ds.blocksize,             -- BYTES NUMBER
  e.ktfbueblks,                            -- BLOCKS NUMBER
  e.ktfbuefno                              -- RELATIVE_FNO NUMBER
from
  v$logmnr_sys_dba_segs ds,
  x$logmnr_ktfbue e,
  x$logmnr_file$ f
where
  e.ktfbuesegfno = ds.relative_fno and e.ktfbuesegbno = ds.header_block and e.ktfbuesegtsn = ds.tablespace_id and e.ktfbuesegtsn = f.ts# and e.ktfbuefno = f.relfile# and bitand(NVL(ds.segment_flags, 0), 1) = 1 and bitand(NVL(ds.segment_flags,0), 65536) = 0