DBA Data[Home] [Help]

VIEW: SYS.CDB_LOBS

Source

View Text - Preformatted

SELECT "OWNER","TABLE_NAME","COLUMN_NAME","SEGMENT_NAME","TABLESPACE_NAME","INDEX_NAME","CHUNK","PCTVERSION","RETENTION","FREEPOOLS","CACHE","LOGGING","ENCRYPT","COMPRESSION","DEDUPLICATION","IN_ROW","FORMAT","PARTITIONED","SECUREFILE","SEGMENT_CREATED","RETENTION_TYPE","RETENTION_VALUE","CON_ID" FROM CONTAINERS("SYS"."DBA_LOBS")
View Text - HTML Formatted

SELECT "OWNER"
, "TABLE_NAME"
, "COLUMN_NAME"
, "SEGMENT_NAME"
, "TABLESPACE_NAME"
, "INDEX_NAME"
, "CHUNK"
, "PCTVERSION"
, "RETENTION"
, "FREEPOOLS"
, "CACHE"
, "LOGGING"
, "ENCRYPT"
, "COMPRESSION"
, "DEDUPLICATION"
, "IN_ROW"
, "FORMAT"
, "PARTITIONED"
, "SECUREFILE"
, "SEGMENT_CREATED"
, "RETENTION_TYPE"
, "RETENTION_VALUE"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_LOBS")