3.5 ALL_PART_LOBS
ALL_PART_LOBS
displays table-level information about the partitioned LOBs accessible to the current user, including default attributes for LOB data partitions.
Related Views
-
DBA_PART_LOBS
displays table-level information about all partitioned LOBs in the database. -
USER_PART_LOBS
displays table-level information about the partitioned LOBs owned by the current user. This view does not display theTABLE_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the partitioned table containing the LOBs |
|
|
|
Name of the partitioned table containing the LOBs |
|
|
|
Name of the LOB column |
|
|
|
Name of the partitioned LOB |
|
|
|
Name of the partitioned LOB index |
|
|
|
Default value of |
|
|
|
Default value of |
|
|
|
Indicates whether and how the LOB data is cached by default in the buffer cache:
|
|
|
|
Indicates whether LOB data < 4000 bytes is stored by default inline (in the row) ( |
|
|
|
Default tablespace for a LOB data partition to be used when adding a partition |
|
|
|
Default value of |
|
|
|
Default value of |
|
|
|
Default value of |
|
|
|
Default value of |
|
|
|
Default value of |
|
|
|
Default value of Possible values for SecureFiles:
Possible values for BasicFiles:
|
|
|
|
Default value of |
|
|
|
Default value of |
|
|
|
Default value of |
|
|
|
Default value of |
|
|
|
Default
|
|
|
|
Default buffer pool for a LOB data partition to be used when adding a partition:
|
|
|
|
Default Database Smart Flash Cache hint to be used when adding a partition:
Solaris and Oracle Linux functionality only. |
|
|
|
Default cell flash cache hint to be used when adding a partition:
See Also: Oracle Exadata Storage Server Software documentation for more information |
|
|
|
Default value of Possible values for SecureFiles:
Possible value for BasicFiles:
|
|
|
|
Default value of Possible values for SecureFiles:
Possible value for BasicFiles:
|
|
|
|
Default value of Possible values for SecureFiles:
Possible values for BasicFiles:
|
|
|
|
Indicates whether the LOB is SecureFiles ( |
See Also: