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_TAB_PARTITIONS

Object Details

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

[View Source]

Columns

Name	Datatype	Length
TABLE_OWNER	VARCHAR2	(128)
TABLE_NAME	VARCHAR2	(128)
COMPOSITE	VARCHAR2	(3)
PARTITION_NAME	VARCHAR2	(128)
SUBPARTITION_COUNT	NUMBER
HIGH_VALUE	LONG	(0)
HIGH_VALUE_LENGTH	NUMBER
PARTITION_POSITION	NUMBER
TABLESPACE_NAME	VARCHAR2	(30)
PCT_FREE	NUMBER
PCT_USED	NUMBER
INI_TRANS	NUMBER
MAX_TRANS	NUMBER
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	(7)
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)
IS_NESTED	VARCHAR2	(3)
PARENT_TABLE_PARTITION	VARCHAR2	(128)
INTERVAL	VARCHAR2	(3)
SEGMENT_CREATED	VARCHAR2	(4)
INDEXING	VARCHAR2	(4)
INMEMORY	VARCHAR2	(8)
INMEMORY_PRIORITY	VARCHAR2	(8)
INMEMORY_DISTRIBUTE	VARCHAR2	(15)
INMEMORY_COMPRESSION	VARCHAR2	(17)
INMEMORY_DUPLICATE	VARCHAR2	(13)

Query Text

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


SELECT TABLE_OWNER
,      TABLE_NAME
,      COMPOSITE
,      PARTITION_NAME
,      SUBPARTITION_COUNT
,      HIGH_VALUE
,      HIGH_VALUE_LENGTH
,      PARTITION_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
,      IS_NESTED
,      PARENT_TABLE_PARTITION
,      INTERVAL
,      SEGMENT_CREATED
,      INDEXING
,      INMEMORY
,      INMEMORY_PRIORITY
,      INMEMORY_DISTRIBUTE
,      INMEMORY_COMPRESSION
,      INMEMORY_DUPLICATE
FROM SYS.DBA_TAB_PARTITIONS;

Dependencies

[top of page]

SYS.DBA_TAB_PARTITIONS references the following:

SYS: DEFERRED_STG$; NTAB$; OBJ$; SEG$; TAB$; TABCOMPART$; TABPART$; TABPARTV$; TS$; USER$

SYS.DBA_TAB_PARTITIONS is referenced by following:

CTXSYS: DRIUTL - show dependent code
PUBLIC: DBA_TAB_PARTITIONS
SYS: DBMSOBJG2 - show dependent code; DBMS_AUDIT_MGMT - show dependent code; DBMS_EXTENDED_TTS_CHECKS - show dependent code; DBMS_PCLXUTIL - show dependent code; DBMS_REDEFINITION_INTERNAL - show dependent code; DBMS_REDEFINITION_INTERNAL - show dependent code; DBMS_SPACE - show dependent code; DBMS_UTILITY - show dependent code; PRVT_ILM - show dependent code; WRI$_ADV_OBJSPACE_TREND_T