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.DBA_LOB_PARTITIONS

Object Details

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

[View Source]

Columns

Name	Datatype	Length
TABLE_OWNER	VARCHAR2	(128)
TABLE_NAME	VARCHAR2	(128)
COLUMN_NAME	VARCHAR2	(4000)
LOB_NAME	VARCHAR2	(128)
PARTITION_NAME	VARCHAR2	(128)
LOB_PARTITION_NAME	VARCHAR2	(128)
LOB_INDPART_NAME	VARCHAR2	(128)
PARTITION_POSITION	NUMBER
COMPOSITE	VARCHAR2	(3)
CHUNK	NUMBER
PCTVERSION	NUMBER
CACHE	VARCHAR2	(10)
IN_ROW	VARCHAR2	(3)
TABLESPACE_NAME	VARCHAR2	(30)
INITIAL_EXTENT	VARCHAR2	(40)
NEXT_EXTENT	VARCHAR2	(40)
MIN_EXTENTS	VARCHAR2	(40)
MAX_EXTENTS	VARCHAR2	(40)
MAX_SIZE	VARCHAR2	(40)
RETENTION	VARCHAR2	(7)
MINRETENTION	VARCHAR2	(40)
PCT_INCREASE	VARCHAR2	(40)
FREELISTS	VARCHAR2	(40)
FREELIST_GROUPS	VARCHAR2	(40)
LOGGING	VARCHAR2	(7)
BUFFER_POOL	VARCHAR2	(7)
FLASH_CACHE	VARCHAR2	(7)
CELL_FLASH_CACHE	VARCHAR2	(7)
ENCRYPT	VARCHAR2	(4)
COMPRESSION	VARCHAR2	(6)
DEDUPLICATION	VARCHAR2	(15)
SECUREFILE	VARCHAR2	(3)
SEGMENT_CREATED	VARCHAR2	(3)

Query Text

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


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

Dependencies

[top of page]

SYS.DBA_LOB_PARTITIONS references the following:

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

SYS.DBA_LOB_PARTITIONS is referenced by following:

PUBLIC: DBA_LOB_PARTITIONS
SYS: DBMS_DBFS_SFS_ADMIN - show dependent code; DBMS_REDEFINITION_INTERNAL - show dependent code; DBMS_SPACE - show dependent code; DBMS_SPACE_ADMIN - show dependent code; WRI$_ADV_OBJSPACE_TREND_T