eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_LOBS

Object Details

Object Name:	ALL_LOBS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of LOBs contained in tables accessible to the user

[View Source]

Columns

Name	Datatype	Length	Comments
OWNER	VARCHAR2	(128)	Owner of the table containing the LOB
TABLE_NAME	VARCHAR2	(128)	Name of the table containing the LOB
COLUMN_NAME	VARCHAR2	(4000)	Name of the LOB column or attribute
SEGMENT_NAME	VARCHAR2	(128)	Name of the LOB segment
TABLESPACE_NAME	VARCHAR2	(30)	Name of the tablespace containing the LOB segment
INDEX_NAME	VARCHAR2	(128)	Name of the LOB index
CHUNK	NUMBER		Size of the LOB chunk as a unit of allocation/manipulation in bytes
PCTVERSION	NUMBER		Maximum percentage of the LOB space used for versioning
RETENTION	NUMBER		Maximum time duration for versioning of the LOB space
FREEPOOLS	NUMBER		Number of freepools for this LOB segment
CACHE	VARCHAR2	(10)	Is the LOB accessed through the buffer cache?
LOGGING	VARCHAR2	(7)	Are changes to the LOB logged?
ENCRYPT	VARCHAR2	(4)	Is this lob encrypted?
COMPRESSION	VARCHAR2	(6)	What level of compression is used for this lob?
DEDUPLICATION	VARCHAR2	(15)	What kind of deduplication is used for this lob?
IN_ROW	VARCHAR2	(3)	Are some of the LOBs stored with the base row?
FORMAT	VARCHAR2	(15)	Is the LOB storage format dependent on the endianness of the platform?
PARTITIONED	VARCHAR2	(3)	Is the LOB column in a partitioned table?
SECUREFILE	VARCHAR2	(3)	Is the LOB a SECUREFILE LOB?
SEGMENT_CREATED	VARCHAR2	(3)	Is the LOB segment created?
RETENTION_TYPE	VARCHAR2	(7)
RETENTION_VALUE	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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
FROM SYS.ALL_LOBS;

Dependencies

[top of page]

SYS.ALL_LOBS references the following:

SYS: ATTRCOL$; COL$; DEFERRED_STG$; LOB$; LOBCOMPPART$; LOBFRAG$; OBJ$; OBJAUTH$; PARTLOB$; PARTOBJ$; SEG$; TAB$; TS$; USER$

SYS.ALL_LOBS is referenced by following:

PUBLIC: ALL_LOBS
SYS: PRVT_COMPRESSION - show dependent code