Keyword: LOB
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_LOBS | Description of LOBs contained in tables accessible to the user |
| ALL_LOB_PARTITIONS | |
| ALL_LOB_SUBPARTITIONS | |
| ALL_LOB_TEMPLATES | |
| ALL_PART_LOBS | |
| DBA_LOBS | Description of LOBs contained in all tables |
| DBA_LOB_PARTITIONS | |
| DBA_LOB_SUBPARTITIONS | |
| DBA_LOB_TEMPLATES | |
| DBA_PART_LOBS | |
| GV$TEMPORARY_LOBS | Synonym for GV_$TEMPORARY_LOBS |
| USER_LOBS | Description of the user's own LOBs contained in the user's own tables |
| USER_LOB_PARTITIONS | |
| USER_LOB_SUBPARTITIONS | |
| USER_LOB_TEMPLATES | |
| USER_PART_LOBS | |
| V$TEMPORARY_LOBS | Synonym for V_$TEMPORARY_LOBS |
Columns
| Column Name | Description |
|---|---|
| CACHE_LOBS (V$TEMPORARY_LOBS) | |
| CACHE_LOBS (GV$TEMPORARY_LOBS) | |
| LOB_COL_NAME (ALL_LOB_TEMPLATES) | |
| LOB_COL_NAME (DBA_LOB_TEMPLATES) | |
| LOB_COL_NAME (USER_LOB_TEMPLATES) | |
| LOB_INDEX_NAME (USER_PART_LOBS) | |
| LOB_INDEX_NAME (DBA_PART_LOBS) | |
| LOB_INDEX_NAME (ALL_PART_LOBS) | |
| LOB_INDPART_NAME (ALL_LOB_PARTITIONS) | |
| LOB_INDPART_NAME (USER_LOB_PARTITIONS) | |
| LOB_INDPART_NAME (DBA_LOB_PARTITIONS) | |
| LOB_INDSUBPART_NAME (USER_LOB_SUBPARTITIONS) | |
| LOB_INDSUBPART_NAME (ALL_LOB_SUBPARTITIONS) | |
| LOB_INDSUBPART_NAME (DBA_LOB_SUBPARTITIONS) | |
| LOB_NAME (ALL_VARRAYS) | Name of the lob if varray is stored in a lob |
| LOB_NAME (DBA_LOB_PARTITIONS) | |
| LOB_NAME (DBA_LOB_SUBPARTITIONS) | |
| LOB_NAME (ALL_PART_LOBS) | |
| LOB_NAME (USER_PART_LOBS) | |
| LOB_NAME (USER_LOB_PARTITIONS) | |
| LOB_NAME (ALL_LOB_PARTITIONS) | |
| LOB_NAME (USER_LOB_SUBPARTITIONS) | |
| LOB_NAME (ALL_LOB_SUBPARTITIONS) | |
| LOB_NAME (DBA_PART_LOBS) | |
| LOB_NAME (USER_VARRAYS) | Name of the lob if varray is stored in a lob |
| LOB_NAME (DBA_VARRAYS) | Name of the lob if varray is stored in a lob |
| LOB_PARTITION_NAME (ALL_LOB_PARTITIONS) | |
| LOB_PARTITION_NAME (ALL_LOB_SUBPARTITIONS) | |
| LOB_PARTITION_NAME (USER_LOB_PARTITIONS) | |
| LOB_PARTITION_NAME (DBA_LOB_SUBPARTITIONS) | |
| LOB_PARTITION_NAME (DBA_LOB_PARTITIONS) | |
| LOB_PARTITION_NAME (USER_LOB_SUBPARTITIONS) | |
| LOB_READS (V$AW_OLAP) | |
| LOB_READS (GV$AW_OLAP) | |
| LOB_SEGMENT_NAME (USER_LOB_TEMPLATES) | |
| LOB_SEGMENT_NAME (DBA_LOB_TEMPLATES) | |
| LOB_SEGMENT_NAME (ALL_LOB_TEMPLATES) | |
| LOB_SUBPARTITION_NAME (DBA_LOB_SUBPARTITIONS) | |
| LOB_SUBPARTITION_NAME (USER_LOB_SUBPARTITIONS) | |
| LOB_SUBPARTITION_NAME (ALL_LOB_SUBPARTITIONS) | |
| NOCACHE_LOBS (V$TEMPORARY_LOBS) | |
| NOCACHE_LOBS (GV$TEMPORARY_LOBS) |