VIEW: SYS.CDB_LOB_PARTITIONS

Source

View Text - Preformatted

SELECT "TABLE_OWNER","TABLE_NAME","COLUMN_NAME","LOB_NAME","PARTITION_NAME","LOB_PARTITION_NAME","LOB_INDPART_NAME","PARTITION_POSITION","COMPOSITE","CHUNK","PCTVERSION","CACHE","IN_ROW","TABLESPACE_NAME","INITIAL_EXTENT","NEXT_EXTENT","MIN_EXTENTS","MAX_EXTENTS","MAX_SIZE","RETENTION","MINRETENTION","PCT_INCREASE","FREELISTS","FREELIST_GROUPS","LOGGING","BUFFER_POOL","FLASH_CACHE","CELL_FLASH_CACHE","ENCRYPT","COMPRESSION","DEDUPLICATION","SECUREFILE","SEGMENT_CREATED","CON_ID" FROM CONTAINERS("SYS"."DBA_LOB_PARTITIONS")

View Text - HTML Formatted

SELECT "TABLE_OWNER"
, "TABLE_NAME"
, "COLUMN_NAME"
, "LOB_NAME"
, "PARTITION_NAME"
, "LOB_PARTITION_NAME"
, "LOB_INDPART_NAME"
, "PARTITION_POSITION"
, "COMPOSITE"
, "CHUNK"
, "PCTVERSION"
, "CACHE"
, "IN_ROW"
, "TABLESPACE_NAME"
, "INITIAL_EXTENT"
, "NEXT_EXTENT"
, "MIN_EXTENTS"
, "MAX_EXTENTS"
, "MAX_SIZE"
, "RETENTION"
, "MINRETENTION"
, "PCT_INCREASE"
, "FREELISTS"
, "FREELIST_GROUPS"
, "LOGGING"
, "BUFFER_POOL"
, "FLASH_CACHE"
, "CELL_FLASH_CACHE"
, "ENCRYPT"
, "COMPRESSION"
, "DEDUPLICATION"
, "SECUREFILE"
, "SEGMENT_CREATED"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_LOB_PARTITIONS")