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 |