select
  inst_id,                                 -- INST_ID NUMBER
  decode(                                  -- OBJECT_TYPE VARCHAR2(18)
    bitand(t.property, 8192), 8192, 'NESTED TABLE', 'TABLE'),
  2,                                       -- OBJECT_TYPE_ID NUMBER
  5,                                       -- SEGMENT_TYPE_ID NUMBER
  t.obj#,                                  -- OBJECT_ID NUMBER
  t.file#,                                 -- HEADER_FILE NUMBER
  t.block#,                                -- HEADER_BLOCK NUMBER
  t.ts#                                    -- TS_NUMBER NUMBER
from
  x$logmnr_tab$ t
where
  bitand(t.property, 1024) = 0 /* exclude clustered tables */
union all
select
  inst_id,                                 -- INST_ID NUMBER
  'TABLE PARTITION',                       -- OBJECT_TYPE VARCHAR2(18)
  19,                                      -- OBJECT_TYPE_ID NUMBER
  5,                                       -- SEGMENT_TYPE_ID NUMBER
  tp.obj#,                                 -- OBJECT_ID NUMBER
  tp.file#,                                -- HEADER_FILE NUMBER
  tp.block#,                               -- HEADER_BLOCK NUMBER
  tp.ts#                                   -- TS_NUMBER NUMBER
from
  x$logmnr_tabpart$ tp
union all
select
  inst_id,                                 -- INST_ID NUMBER
  'CLUSTER',                               -- OBJECT_TYPE VARCHAR2(18)
  3,                                       -- OBJECT_TYPE_ID NUMBER
  5,                                       -- SEGMENT_TYPE_ID NUMBER
  c.obj#,                                  -- OBJECT_ID NUMBER
  c.file#,                                 -- HEADER_FILE NUMBER
  c.block#,                                -- HEADER_BLOCK NUMBER
  c.ts#                                    -- TS_NUMBER NUMBER
from
  x$logmnr_clu$ c
union all
select
  inst_id,                                 -- INST_ID NUMBER
  decode(                                  -- OBJECT_TYPE VARCHAR2(18)
    i.type#, 8, 'LOBINDEX', 'INDEX'),
  1,                                       -- OBJECT_TYPE_ID NUMBER
  6,                                       -- SEGMENT_TYPE_ID NUMBER
  i.obj#,                                  -- OBJECT_ID NUMBER
  i.file#,                                 -- HEADER_FILE NUMBER
  i.block#,                                -- HEADER_BLOCK NUMBER
  i.ts#                                    -- TS_NUMBER NUMBER
from
  x$logmnr_ind$ i
where
  i.type# in (1, 2, 3, 4, 6, 7, 8, 9)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  'INDEX PARTITION',                       -- OBJECT_TYPE VARCHAR2(18)
  20,                                      -- OBJECT_TYPE_ID NUMBER
  6,                                       -- SEGMENT_TYPE_ID NUMBER
  ip.obj#,                                 -- OBJECT_ID NUMBER
  ip.file#,                                -- HEADER_FILE NUMBER
  ip.block#,                               -- HEADER_BLOCK NUMBER
  ip.ts#                                   -- TS_NUMBER NUMBER
from
  x$logmnr_indpart$ ip
union all
select
  inst_id,                                 -- INST_ID NUMBER
  'LOBSEGMENT',                            -- OBJECT_TYPE VARCHAR2(18)
  21,                                      -- OBJECT_TYPE_ID NUMBER
  8,                                       -- SEGMENT_TYPE_ID NUMBER
  l.lobj#,                                 -- OBJECT_ID NUMBER
  l.file#,                                 -- HEADER_FILE NUMBER
  l.block#,                                -- HEADER_BLOCK NUMBER
  l.ts#                                    -- TS_NUMBER NUMBER
from
  x$logmnr_lob$ l
where
  (bitand(l.property, 64) = 0) or (bitand(l.property, 128) = 128)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  'TABLE SUBPARTITION',                    -- OBJECT_TYPE VARCHAR2(18)
  34,                                      -- OBJECT_TYPE_ID NUMBER
  5,                                       -- SEGMENT_TYPE_ID NUMBER
  tsp.obj#,                                -- OBJECT_ID NUMBER
  tsp.file#,                               -- HEADER_FILE NUMBER
  tsp.block#,                              -- HEADER_BLOCK NUMBER
  tsp.ts#                                  -- TS_NUMBER NUMBER
from
  x$logmnr_tabsubpart$ tsp
union all
select
  inst_id,                                 -- INST_ID NUMBER
  'INDEX SUBPARTITION',                    -- OBJECT_TYPE VARCHAR2(18)
  35,                                      -- OBJECT_TYPE_ID NUMBER
  6,                                       -- SEGMENT_TYPE_ID NUMBER
  isp.obj#,                                -- OBJECT_ID NUMBER
  isp.file#,                               -- HEADER_FILE NUMBER
  isp.block#,                              -- HEADER_BLOCK NUMBER
  isp.ts#                                  -- TS_NUMBER NUMBER
from
  x$logmnr_indsubpart$ isp
union all
select
  inst_id,                                 -- INST_ID NUMBER
  decode(                                  -- OBJECT_TYPE VARCHAR2(18)
    lf.fragtype$, 'P', 'LOB PARTITION', 'LOB SUBPARTITION'),
  decode(                                  -- OBJECT_TYPE_ID NUMBER
    lf.fragtype$, 'P', 40, 41),
  8,                                       -- SEGMENT_TYPE_ID NUMBER
  lf.fragobj#,                             -- OBJECT_ID NUMBER
  lf.file#,                                -- HEADER_FILE NUMBER
  lf.block#,                               -- HEADER_BLOCK NUMBER
  lf.ts#                                   -- TS_NUMBER NUMBER
from
  x$logmnr_lobfrag$ lf