Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
ALL_LOBS
displays the large objects (LOBs) contained in tables accessible to the current user. LOBs include binary large objects (BLOBs) and character large objects (CLOBs). Binary files (BFILEs) are stored outside the database, so they are not displayed by this view or the related views.
Related Views
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.
Column | Datatype | NULL | Description |
---|---|---|---|
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 ) |
|
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:
|
|
PARTITIONED |
VARCHAR2(3) |
Indicates whether the LOB column is in a partitioned table (YES ) or not (NO ) |