Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_LOB_PARTITIONS

ALL_LOB_PARTITIONS displays LOB partitions contained in tables accessible to the current user.

Related Views

Column Datatype NULL Description
TABLE_OWNER VARCHAR2(30)   Owner of the table
TABLE_NAME VARCHAR2(30)   Name of the table
COLUMN_NAME VARCHAR2(4000)   Name of the LOB column
LOB_NAME VARCHAR2(30)   Name of the partitioned LOB item
PARTITION_NAME VARCHAR2(30)   Name of the table partition
LOB_PARTITION_NAME VARCHAR2(30)   Name of the LOB data partition
LOB_INDPART_NAME VARCHAR2(30)   Name of the corresponding LOB index partition
PARTITION_POSITION NUMBER   Position of the LOB data partition within the LOB item
COMPOSITE VARCHAR2(3)   Whether the partition is composite (YES | NO)
CHUNK NUMBER   Value of the CHUNK attribute of the LOB data partition
PCTVERSION NUMBER   Value of the PCTVERSION attribute of the LOB data partition
CACHE VARCHAR2(10)   Whether and how the cluster is to be cached in the buffer cache (CACHE, NOCACHE, CACHEREADS)
IN_ROW VARCHAR2(3)   Whether the STORAGE IN ROW attribute is enabled for the LOB data partition
TABLESPACE_NAME VARCHAR2(30)   Name of the tablespace containing the LOB data partition
INITIAL_EXTENT VARCHAR2(40)   Size in bytes of the initial extent of the LOB data partition
NEXT_EXTENT VARCHAR2(40)   Size in bytes of secondary extents of the LOB data partition
MIN_EXTENTS VARCHAR2(40)   Minimum number of extents allowed in the segment of the LOB data partition
MAX_EXTENTS VARCHAR2(40)   Maximum number of extents allowed in the segment of the LOB data partition
PCT_INCREASE VARCHAR2(40)   Percentage increase in extent size for the LOB data partition
FREELISTS VARCHAR2(40)   Number of process freelists allocated in the segment of the LOB data partition
FREELIST_GROUPS VARCHAR2(40)   Number of freelist groups allocated in the segment of the LOB data partition
LOGGING VARCHAR2(7)   Logging attribute of the LOB data partition
BUFFER_POOL VARCHAR2(7)   Default buffer pool for the LOB partition blocks