2.199 ALL_LOB_PARTITIONS
ALL_LOB_PARTITIONS
displays the LOB partitions in the tables accessible to the current user.
Related Views
-
DBA_LOB_PARTITIONS
displays all LOB partitions in the database. -
USER_LOB_PARTITIONS
displays the LOB partitions owned by the current user. This view does not display theTABLE_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table |
|
|
|
Name of the table |
|
|
|
Name of the LOB column |
|
|
|
Name of the partitioned LOB item |
|
|
|
Name of the table partition |
|
|
|
Name of the LOB data partition |
|
|
|
Name of the corresponding LOB index partition |
|
|
|
Position of the LOB data partition within the LOB item |
|
|
|
Indicates whether the partition is composite ( |
|
|
|
Value of the |
|
|
|
Value of the |
|
|
|
Indicates whether and how the LOB data is to be cached in the buffer cache:
|
|
|
|
Indicates whether the |
|
|
|
Name of the tablespace containing the LOB data partition |
|
|
|
Size (in bytes) of the initial extent of the LOB data partition, or |
|
|
|
Size (in bytes) of secondary extents of the LOB data partition, or |
|
|
|
Minimum number of extents allowed in the segment of the LOB data partition, or |
|
|
|
Maximum number of extents allowed in the segment of the LOB data partition, or |
|
|
|
Maximum number of blocks allowed in the segment of the LOB data partition, or |
|
|
|
Retention option. Possible values for a SecureFiles segment:
Possible values for a BasicFiles segment:
|
|
|
|
Minimum retention duration for a SecureFiles segment, or |
|
|
|
Percentage increase in extent size for the LOB data partition, or |
|
|
|
Number of process freelists allocated in the segment of the LOB data partition, or |
|
|
|
Number of freelist groups allocated in the segment of the LOB data partition, or |
|
|
|
Indicates whether or not changes to the LOB are logged:
|
|
|
|
Buffer pool for the LOB partition blocks:
|
|
|
|
Database Smart Flash Cache hint to be used for partition blocks:
Solaris and Oracle Linux functionality only. |
|
|
|
Cell flash cache hint to be used for partition blocks:
See Also: Oracle Exadata Storage Server Software documentation for more information |
|
|
|
Indicates whether or not the LOB is encrypted. Possible values for SecureFiles:
Possible value for BasicFiles:
|
|
|
|
Level of compression used for this LOB. Possible values for SecureFiles:
Possible value for BasicFiles:
|
|
|
|
Kind of deduplication used for this LOB. Possible values for SecureFiles:
Possible value for BasicFiles:
|
|
|
|
Indicates whether the LOB is SecureFiles ( |
|
|
|
Indicates whether the LOB partition segment has been created ( |
See Also: