[Home] [Help]
[Dependency Information]
TABLE: SYS.INDPART$
Object Details
Object Name: | INDPART$ |
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_INDPART_BOPART$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
BO#
PART#
|
I_INDPART_OBJ$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
|
SYS_IL0000000206C00028$$
|
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) |
|
|
FLAGS |
NUMBER |
|
Yes |
|
TS# |
NUMBER |
|
Yes |
|
FILE# |
NUMBER |
|
Yes |
|
BLOCK# |
NUMBER |
|
Yes |
|
PCTFREE$ |
NUMBER |
|
Yes |
|
PCTTHRES$ |
NUMBER |
|
|
|
INITRANS |
NUMBER |
|
Yes |
|
MAXTRANS |
NUMBER |
|
Yes |
|
ANALYZETIME |
DATE |
|
|
|
SAMPLESIZE |
NUMBER |
|
|
|
ROWCNT |
NUMBER |
|
|
|
BLEVEL |
NUMBER |
|
|
|
LEAFCNT |
NUMBER |
|
|
|
DISTKEY |
NUMBER |
|
|
|
LBLKKEY |
NUMBER |
|
|
|
DBLKKEY |
NUMBER |
|
|
|
CLUFAC |
NUMBER |
|
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
NUMBER |
|
|
|
INCLCOL |
NUMBER |
|
|
|
BHIBOUNDVAL |
BLOB |
(4000) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, DATAOBJ#
, BO#
, PART#
, HIBOUNDLEN
, HIBOUNDVAL
, FLAGS
, TS#
, FILE#
, BLOCK#
, PCTFREE$
, PCTTHRES$
, INITRANS
, MAXTRANS
, ANALYZETIME
, SAMPLESIZE
, ROWCNT
, BLEVEL
, LEAFCNT
, DISTKEY
, LBLKKEY
, DBLKKEY
, CLUFAC
, SPARE1
, SPARE2
, SPARE3
, INCLCOL
, BHIBOUNDVAL
FROM SYS.INDPART$;
Dependencies
[top of page]
SYS.INDPART$ does not reference any database object
SYS.INDPART$ is referenced by following:
-
CTXSYS
-
DRIREPZ
- show dependent code
-
SYS
-
ALL_IND_PARTITIONS
-
ALL_IND_PENDING_STATS
-
ALL_USTATS
-
DBA_IND_PARTITIONS
-
DBA_IND_PENDING_STATS
-
DBA_USTATS
-
DBMSOBJG
- show dependent code
-
DBMS_EXTENDED_TTS_CHECKS
- 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_INTERNAL_LOGSTDBY
- show dependent code
-
DBMS_LOGMNR_D
- show dependent code
-
DBMS_LOGMNR_FFVTOLOGMNRT
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_METADATA_UTIL
- 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
-
EXT_TO_OBJ_VIEW
-
EXU81TTS
-
EXU8IXP
-
EXU8USCU
-
EXU9EIP
-
EXU9LBP
-
EXU9LTTS
-
INDEX_ORPHANED_ENTRY_V$
-
INDEX_STATS
-
INDPARTV$
-
KU$_10_1_PIND_STATS_VIEW
-
KU$_IND_PART_VIEW
-
KU$_IND_SUBNAME_VIEW
-
KU$_IOTPART_BYTES_ALLOC_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_LOBFRAGINDEX_VIEW
-
KU$_PIND_STATS_VIEW
-
KU$_PIOT_PART_VIEW
-
KU$_TAB_SUBNAME_VIEW
-
KU$_TTSP_INDPARTVIEW
-
KU$_TTS_INDPARTVIEW
-
KU$_TTS_IND_VIEW
-
KU$_TTS_MV_VIEW
-
KU$_TTS_VIEW
-
LOGMNR_DICT_CACHE
- show dependent code
-
LOGMNR_KRVRDLUID3
- show dependent code
-
PRVT_ILM
- show dependent code
-
STRADDLING_RS_OBJECTS
-
STRADDLING_TS_OBJECTS
-
SYS_OBJECTS
-
USER_IND_PARTITIONS
-
USER_IND_PENDING_STATS
-
USER_USTATS
-
_utl$_gp_ind_parts
-
_utl$_lnc_ind_parts