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

Part Number B14237-01
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_PART_LOBS

ALL_PART_LOBS provides table-level information about partitioned LOBs that are accessible to the current user, including default attributes for LOB data partitions.

Related Views

Column Datatype NULL Description
TABLE_OWNER VARCHAR2(30) NOT NULL Owner of the partitioned table containing LOB(s)
TABLE_NAME VARCHAR2(30) NOT NULL Name of the partitioned table containing LOB(s)
COLUMN_NAME VARCHAR2(4000)   Name of the LOB column
LOB_NAME VARCHAR2(30) NOT NULL Name of the partitioned LOB
LOB_INDEX_NAME VARCHAR2(30) NOT NULL Name of the partitioned LOB index
DEF_CHUNK NUMBER NOT NULL Default value of CHUNK for a LOB data partition to be used when adding a partition
DEF_PCTVERSION NUMBER NOT NULL Default value of PCTVERSION for a LOB data partition to be used when adding a partition
DEF_CACHE VARCHAR2(10)
Whether and how the cluster is to be cached by default in the buffer cache (CACHE, NOCACHE, CACHEREADS)
DEF_IN_ROW VARCHAR2(3)
Whether LOB data < 4000 bytes is stored in the row (inline)—that is, whether ENABLE STORAGE IN ROW was specified when the LOB column was created or last altered
DEF_TABLESPACE_NAME VARCHAR2(30)
Default tablespace for a LOB data partition to be used when adding a partition
DEF_INITIAL_EXTENT VARCHAR2(40)
Default value of INITIAL for a LOB data partition to be used when adding a partition
DEF_NEXT_EXTENT VARCHAR2(40)
Default value of NEXT for a LOB data partition to be used when adding a partition
DEF_MIN_EXTENTS VARCHAR2(40)
Default value of MINEXTENT for a LOB data partition to be used when adding a partition
DEF_MAX_EXTENTS VARCHAR2(40)
Default value of MAXEXTENTS for a LOB data partition to be used when adding a partition
DEF_PCT_INCREASE VARCHAR2(40)
Default value of PCTINCREASE for a LOB data partition to be used when adding a partition
DEF_FREELISTS VARCHAR2(40)
Default value of FREELISTS for a LOB data partition to be used when adding a partition
DEF_FREELIST_GROUPS VARCHAR2(40)
Default value of FREELIST GROUPS for a LOB data partition to be used when adding a partition
DEF_LOGGING VARCHAR2(7)
Default LOGGING attribute for a LOB data partition to be used when adding a partition
DEF_BUFFER_POOL VARCHAR2(7)
Default buffer pool for a LOB data partition to be used when adding a partition