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

Object Details

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

in all containers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TABLE_OWNER	VARCHAR2	(128)	Yes
TABLE_NAME	VARCHAR2	(128)	Yes
PARTITION_NAME	VARCHAR2	(128)
SUBPARTITION_NAME	VARCHAR2	(128)
HIGH_VALUE_LENGTH	NUMBER
SUBPARTITION_POSITION	NUMBER
TABLESPACE_NAME	VARCHAR2	(30)
PCT_FREE	NUMBER		Yes
PCT_USED	NUMBER
INI_TRANS	NUMBER
MAX_TRANS	NUMBER		Yes
INITIAL_EXTENT	NUMBER
NEXT_EXTENT	NUMBER
MIN_EXTENT	NUMBER
MAX_EXTENT	NUMBER
MAX_SIZE	NUMBER
PCT_INCREASE	NUMBER
FREELISTS	NUMBER
FREELIST_GROUPS	NUMBER
LOGGING	VARCHAR2	(3)
COMPRESSION	VARCHAR2	(8)
COMPRESS_FOR	VARCHAR2	(30)
NUM_ROWS	NUMBER
BLOCKS	NUMBER
EMPTY_BLOCKS	NUMBER
AVG_SPACE	NUMBER
CHAIN_CNT	NUMBER
AVG_ROW_LEN	NUMBER
SAMPLE_SIZE	NUMBER
LAST_ANALYZED	DATE
BUFFER_POOL	VARCHAR2	(7)
FLASH_CACHE	VARCHAR2	(7)
CELL_FLASH_CACHE	VARCHAR2	(7)
GLOBAL_STATS	VARCHAR2	(3)
USER_STATS	VARCHAR2	(3)
INTERVAL	VARCHAR2	(3)
SEGMENT_CREATED	VARCHAR2	(3)
INDEXING	VARCHAR2	(3)
INMEMORY	VARCHAR2	(8)
INMEMORY_PRIORITY	VARCHAR2	(8)
INMEMORY_DISTRIBUTE	VARCHAR2	(15)
INMEMORY_COMPRESSION	VARCHAR2	(17)
INMEMORY_DUPLICATE	VARCHAR2	(13)
CON_ID	NUMBER			container id

Query Text

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


SELECT TABLE_OWNER
,      TABLE_NAME
,      PARTITION_NAME
,      SUBPARTITION_NAME
,      HIGH_VALUE_LENGTH
,      SUBPARTITION_POSITION
,      TABLESPACE_NAME
,      PCT_FREE
,      PCT_USED
,      INI_TRANS
,      MAX_TRANS
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENT
,      MAX_EXTENT
,      MAX_SIZE
,      PCT_INCREASE
,      FREELISTS
,      FREELIST_GROUPS
,      LOGGING
,      COMPRESSION
,      COMPRESS_FOR
,      NUM_ROWS
,      BLOCKS
,      EMPTY_BLOCKS
,      AVG_SPACE
,      CHAIN_CNT
,      AVG_ROW_LEN
,      SAMPLE_SIZE
,      LAST_ANALYZED
,      BUFFER_POOL
,      FLASH_CACHE
,      CELL_FLASH_CACHE
,      GLOBAL_STATS
,      USER_STATS
,      INTERVAL
,      SEGMENT_CREATED
,      INDEXING
,      INMEMORY
,      INMEMORY_PRIORITY
,      INMEMORY_DISTRIBUTE
,      INMEMORY_COMPRESSION
,      INMEMORY_DUPLICATE
,      CON_ID
FROM SYS.CDB_TAB_SUBPARTITIONS;

Dependencies

[top of page]

SYS.CDB_TAB_SUBPARTITIONS does not reference any database object

SYS.CDB_TAB_SUBPARTITIONS is referenced by following:

PUBLIC: CDB_TAB_SUBPARTITIONS