Tablespace Differs Between DBA_LOBS and DBA_SEGMENTS
Hi,
Am I missing something here or are DBA_LOBS and DBA_SEGMENTS reporting different tablespaces for the LOB (and hence one is incorrect)?
SELECT dl.owner,
dl.segment_name,
dl.tablespace_name,
ds.tablespace_name
FROM dba_lobs dl
JOIN dba_segments ds ON ds.owner = dl.owner AND ds.segment_name = dl.segment_name
WHERE dl.tablespace_name != ds.tablespace_name
;
OWNER SEGMENT_NAME TABLESPACE_NAME TABLESPACE_NAME_1
----------------------- ----------------------------------------------- --------------------------------- -------------------------------------
CDC_STG_PUB SYS_LOB0001163271C00011$$ CDC_DATA REORG
CDC_STG_PUB SYS_LOB0001163281C00011$$ CDC_DATA REORG
CDC_STG_PUB SYS_LOB0001163289C00011$$ CDC_DATA REORG
Am I missing something here or are DBA_LOBS and DBA_SEGMENTS reporting different tablespaces for the LOB (and hence one is incorrect)?
SELECT dl.owner,
dl.segment_name,
dl.tablespace_name,
ds.tablespace_name
FROM dba_lobs dl
JOIN dba_segments ds ON ds.owner = dl.owner AND ds.segment_name = dl.segment_name
WHERE dl.tablespace_name != ds.tablespace_name
;
OWNER SEGMENT_NAME TABLESPACE_NAME TABLESPACE_NAME_1
----------------------- ----------------------------------------------- --------------------------------- -------------------------------------
CDC_STG_PUB SYS_LOB0001163271C00011$$ CDC_DATA REORG
CDC_STG_PUB SYS_LOB0001163281C00011$$ CDC_DATA REORG
CDC_STG_PUB SYS_LOB0001163289C00011$$ CDC_DATA REORG
0