Database Administration (MOSC)

MOSC Banner

Tablespace Differs Between DBA_LOBS and DBA_SEGMENTS

edited Oct 19, 2010 6:32AM in Database Administration (MOSC) 1 commentAnswered ✓
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center