OWNER |
VARCHAR2(30) |
|
Owner of the object containing the LOB |
TABLE_NAME |
VARCHAR2(30) |
|
Name of the object containing the LOB |
COLUMN_NAME |
VARCHAR2(4000) |
|
Name of the LOB column or attribute |
SEGMENT_NAME |
VARCHAR2(30) |
|
Name of the LOB segment |
TABLESPACE_NAME |
VARCHAR2(30) |
|
Name of the tablespace containing the LOB segment |
INDEX_NAME |
VARCHAR2(30) |
|
Name of the LOB index |
CHUNK |
NUMBER |
|
Size (in bytes) of the LOB chunk as a unit of allocation or manipulation |
PCTVERSION |
NUMBER |
|
Maximum percentage of the LOB space used for versioning |
RETENTION |
NUMBER |
|
Maximum time duration for versioning of the LOB space |
FREEPOOLS |
NUMBER |
|
Number of freepools for this LOB segment |
CACHE |
VARCHAR2(10) |
|
Indicates whether and how the cluster is to be cached in the buffer cache (YES, NO, CACHEREADS) |
LOGGING |
VARCHAR2(7) |
|
Indicates whether changes to the LOB are logged (YES) or not (NO) |
ENCRYPT |
VARCHAR2(3) |
|
Whether or not the LOB is encrypted |
COMPRESSION |
VARCHAR2(6) |
|
The level of compression used for this LOB |
DEDUPLICATION |
VARCHAR2(15) |
|
The kind of deduplication used for this LOB |
IN_ROW |
VARCHAR2(3) |
|
Indicates whether some of the LOBs are stored inline with the base row (YES) or not (NO). For partitioned objects, refer to the *_LOB_PARTITIONS and *_PART_LOBS views. |
FORMAT |
VARCHAR2(15) |
|
Indicates whether the LOB storage format is dependent on the endianness of the platform:
-
NOT APPLICABLE
-
ENDIAN SPECIFIC
-
ENDIAN NEUTRAL
|
PARTITIONED |
VARCHAR2(3) |
|
Indicates whether the LOB column is in a partitioned table (YES) or not (NO) |
SECUREFILE |
VARCHAR2(3) |
|
Indicates whether the LOB is a SecureFile LOB (YES) or not (NO) |
