Oracle_USER_LOBS1
Objectives: Diff betwen DBA_LOBS and USER_LOBS


DBA_LOBS describes all LOBs in the database.

USER_LOBS describes the LOBs owned by the current user. This view does not display the OWNER column.
 
Script:

select table_name || '.' || column_name table_column, segment_name lob_name, in_row from USER_LOBS where rownum <20

DBA_LOBS

select owner,table_name || '.' || column_name table_column, segment_name lob_name, in_row from DBA_LOBS where rownum <20