[Home] [Help]
[Dependency Information]
TABLE: SYS.TABPART$
Object Details
Object Name: | TABPART$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 10 |
PCT Used: | 40 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_TABPART_BOPART$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
BO#
PART#
|
I_TABPART_OBJ$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
|
SYS_IL0000000203C00026$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
DATAOBJ# |
NUMBER |
|
|
|
BO# |
NUMBER |
|
Yes |
|
PART# |
NUMBER |
|
Yes |
|
HIBOUNDLEN |
NUMBER |
|
Yes |
|
HIBOUNDVAL |
LONG |
(0) |
|
|
TS# |
NUMBER |
|
|
|
FILE# |
NUMBER |
|
|
|
BLOCK# |
NUMBER |
|
|
|
PCTFREE$ |
NUMBER |
|
Yes |
|
PCTUSED$ |
NUMBER |
|
Yes |
|
INITRANS |
NUMBER |
|
Yes |
|
MAXTRANS |
NUMBER |
|
Yes |
|
FLAGS |
NUMBER |
|
Yes |
|
ANALYZETIME |
DATE |
|
|
|
SAMPLESIZE |
NUMBER |
|
|
|
ROWCNT |
NUMBER |
|
|
|
BLKCNT |
NUMBER |
|
|
|
EMPCNT |
NUMBER |
|
|
|
AVGSPC |
NUMBER |
|
|
|
CHNCNT |
NUMBER |
|
|
|
AVGRLN |
NUMBER |
|
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
NUMBER |
|
|
|
BHIBOUNDVAL |
BLOB |
(4000) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, DATAOBJ#
, BO#
, PART#
, HIBOUNDLEN
, HIBOUNDVAL
, TS#
, FILE#
, BLOCK#
, PCTFREE$
, PCTUSED$
, INITRANS
, MAXTRANS
, FLAGS
, ANALYZETIME
, SAMPLESIZE
, ROWCNT
, BLKCNT
, EMPCNT
, AVGSPC
, CHNCNT
, AVGRLN
, SPARE1
, SPARE2
, SPARE3
, BHIBOUNDVAL
FROM SYS.TABPART$;
Dependencies
[top of page]
SYS.TABPART$ does not reference any database object
SYS.TABPART$ is referenced by following:
-
CTXSYS
-
DRIREPZ
- show dependent code
-
DRIXMD
- show dependent code
-
SYS
-
AD_EXTENTS
-
ALL_COL_PENDING_STATS
-
ALL_MVIEW_DETAIL_RELATIONS
-
ALL_OBJECTS
-
ALL_OBJECTS_AE
-
ALL_TAB_HISTGRM_PENDING_STATS
-
ALL_TAB_PARTITIONS
-
ALL_USTATS
-
DBA_COL_PENDING_STATS
-
DBA_MVIEWS
-
DBA_MVIEW_DETAIL_PARTITION
-
DBA_MVIEW_DETAIL_RELATIONS
-
DBA_TAB_HISTGRM_PENDING_STATS
-
DBA_TAB_PARTITIONS
-
DBA_USTATS
-
DBMSOBJG
- show dependent code
-
DBMS_FEATURE_DEFERRED_SEG_CRT
- show dependent code
-
DBMS_FEATURE_PARTITION_SYSTEM
- show dependent code
-
DBMS_FEATURE_PARTITION_USER
- show dependent code
-
DBMS_FEATURE_SEG_MAIN_ONL_COMP
- show dependent code
-
DBMS_ILM_ADMIN
- show dependent code
-
DBMS_LOGMNR_FFVTOLOGMNRT
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_METADATA_UTIL
- show dependent code
-
DBMS_PARALLEL_EXECUTE_EXTENTS
-
DBMS_PITR
- show dependent code
-
DBMS_PLUGTS
- show dependent code
-
DBMS_STATS
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
EXPCOMPRESSEDPART
-
EXPPIOTMAP
-
EXT_TO_OBJ_VIEW
-
EXU81TTS
-
EXU8IXP
-
EXU8TBP
-
EXU9LBP
-
EXU9LTTS
-
KU$_10_1_PTAB_COL_STATS_VIEW
-
KU$_10_1_PTAB_STATS_VIEW
-
KU$_EQNTABLE_BYTES_ALLOC_VIEW
-
KU$_EQNTABLE_DATA_VIEW
-
KU$_HISTGRM_VIEW
-
KU$_HNTP_VIEW
-
KU$_HTPART_BYTES_ALLOC_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_IND_PART_VIEW
-
KU$_IND_SUBNAME_VIEW
-
KU$_NTPART_PARENT_VIEW
-
KU$_NTPART_VIEW
-
KU$_OV_TABPART_VIEW
-
KU$_PARTITION_EST_VIEW
-
KU$_PTAB_STATS_VIEW
-
KU$_TAB_PART_VIEW
-
KU$_TAB_SUBNAME_VIEW
-
KU$_TTSP_INDPARTVIEW
-
KU$_TTS_MVL_VIEW
-
KU$_TTS_MV_VIEW
-
KU$_TTS_PARTLOBVIEW
-
KU$_TTS_TABPARTVIEW
-
KU$_TTS_VIEW
-
LOADER_PART_INFO
-
LOGMNR_DICT_CACHE
- show dependent code
-
LOGMNR_KRVRDLUID3
- show dependent code
-
PRVT_COMPRESS
- show dependent code
-
PRVT_ILM
- show dependent code
-
STRADDLING_RS_OBJECTS
-
STRADDLING_TS_OBJECTS
-
SYS_OBJECTS
-
TABPARTV$
-
TP$
-
USER_COL_PENDING_STATS
-
USER_MVIEW_DETAIL_RELATIONS
-
USER_TAB_HISTGRM_PENDING_STATS
-
USER_TAB_PARTITIONS
-
USER_USTATS
-
_user_stat
-
_utl$_lnc_ind_parts