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_SUBPARTITIONS

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
TABLE_OWNER	VARCHAR2	(128)	Yes
TABLE_NAME	VARCHAR2	(128)	Yes
COLUMN_NAME	VARCHAR2	(4000)
LOB_NAME	VARCHAR2	(128)	Yes
LOB_PARTITION_NAME	VARCHAR2	(128)
SUBPARTITION_NAME	VARCHAR2	(128)
LOB_SUBPARTITION_NAME	VARCHAR2	(128)
LOB_INDSUBPART_NAME	VARCHAR2	(128)
SUBPARTITION_POSITION	NUMBER
CHUNK	NUMBER
PCTVERSION	NUMBER
CACHE	VARCHAR2	(10)
IN_ROW	VARCHAR2	(3)
TABLESPACE_NAME	VARCHAR2	(30)	Yes
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	(3)
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
,      LOB_PARTITION_NAME
,      SUBPARTITION_NAME
,      LOB_SUBPARTITION_NAME
,      LOB_INDSUBPART_NAME
,      SUBPARTITION_POSITION
,      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_SUBPARTITIONS;

Dependencies

[top of page]

SYS.DBA_LOB_SUBPARTITIONS references the following:

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

SYS.DBA_LOB_SUBPARTITIONS is referenced by following:

PUBLIC: DBA_LOB_SUBPARTITIONS
SYS: DBMS_SPACE - show dependent code; DBMS_SPACE_ADMIN - show dependent code; WRI$_ADV_OBJSPACE_TREND_T