[Home] [Help]
[Dependency Information]
TABLE: SYS.IND$
Object Details
Object Name: | IND$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 0 |
PCT Used: | 0 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_IND1
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
DATAOBJ# |
NUMBER |
|
|
|
TS# |
NUMBER |
|
Yes |
|
FILE# |
NUMBER |
|
Yes |
|
BLOCK# |
NUMBER |
|
Yes |
|
BO# |
NUMBER |
|
Yes |
|
INDMETHOD# |
NUMBER |
|
Yes |
|
COLS |
NUMBER |
|
Yes |
|
PCTFREE$ |
NUMBER |
|
Yes |
|
INITRANS |
NUMBER |
|
Yes |
|
MAXTRANS |
NUMBER |
|
Yes |
|
PCTTHRES$ |
NUMBER |
|
|
|
TYPE# |
NUMBER |
|
Yes |
|
FLAGS |
NUMBER |
|
Yes |
|
PROPERTY |
NUMBER |
|
Yes |
|
BLEVEL |
NUMBER |
|
|
|
LEAFCNT |
NUMBER |
|
|
|
DISTKEY |
NUMBER |
|
|
|
LBLKKEY |
NUMBER |
|
|
|
DBLKKEY |
NUMBER |
|
|
|
CLUFAC |
NUMBER |
|
|
|
ANALYZETIME |
DATE |
|
|
|
SAMPLESIZE |
NUMBER |
|
|
|
ROWCNT |
NUMBER |
|
|
|
INTCOLS |
NUMBER |
|
Yes |
|
DEGREE |
NUMBER |
|
|
|
INSTANCES |
NUMBER |
|
|
|
TRUNCCNT |
NUMBER |
|
|
|
EVALEDITION# |
NUMBER |
|
|
|
UNUSABLEBEFORE# |
NUMBER |
|
|
|
UNUSABLEBEGINNING# |
NUMBER |
|
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
NUMBER |
|
|
|
SPARE4 |
VARCHAR2 |
(1000) |
|
|
SPARE5 |
VARCHAR2 |
(1000) |
|
|
SPARE6 |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, DATAOBJ#
, TS#
, FILE#
, BLOCK#
, BO#
, INDMETHOD#
, COLS
, PCTFREE$
, INITRANS
, MAXTRANS
, PCTTHRES$
, TYPE#
, FLAGS
, PROPERTY
, BLEVEL
, LEAFCNT
, DISTKEY
, LBLKKEY
, DBLKKEY
, CLUFAC
, ANALYZETIME
, SAMPLESIZE
, ROWCNT
, INTCOLS
, DEGREE
, INSTANCES
, TRUNCCNT
, EVALEDITION#
, UNUSABLEBEFORE#
, UNUSABLEBEGINNING#
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
FROM SYS.IND$;
Dependencies
[top of page]
SYS.IND$ does not reference any database object
SYS.IND$ is referenced by following:
-
CTXSYS
-
DRIREPZ
- show dependent code
-
DRIUTL
- show dependent code
-
DRI_MOVE_CTXSYS
- show dependent code
-
SYS
-
ALL_INDEXES
-
ALL_IND_COLUMNS
-
ALL_IND_EXPRESSIONS
-
ALL_IND_PARTITIONS
-
ALL_IND_PENDING_STATS
-
ALL_IND_STATISTICS
-
ALL_IND_SUBPARTITIONS
-
ALL_OBJECTS
-
ALL_OBJECTS_AE
-
ALL_PART_INDEXES
-
ALL_PART_KEY_COLUMNS
-
ALL_SUBPART_KEY_COLUMNS
-
ALL_XML_INDEXES
-
DBA_INDEXES
-
DBA_IND_COLUMNS
-
DBA_IND_EXPRESSIONS
-
DBA_IND_PARTITIONS
-
DBA_IND_PENDING_STATS
-
DBA_IND_STATISTICS
-
DBA_IND_SUBPARTITIONS
-
DBA_LOGSTDBY_NOT_UNIQUE
-
DBA_OBJECT_USAGE
-
DBA_PART_INDEXES
-
DBA_PART_KEY_COLUMNS
-
DBA_SUBPART_KEY_COLUMNS
-
DBA_XML_INDEXES
-
DBMSOBJG
- show dependent code
-
DBMSOBJG2
- 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_I_INDEX_UTL
- show dependent code
-
DBMS_LOGMNR_D
- show dependent code
-
DBMS_LOGMNR_FFVTOLOGMNRT
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_ODCI
- show dependent code
-
DBMS_PLUGTS
- show dependent code
-
DBMS_REDEFINITION_INTERNAL
- show dependent code
-
DBMS_STATS
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
EXT_TO_OBJ_VIEW
-
EXU10TABS
-
EXU10USCI
-
EXU112DLOB
-
EXU11IND_BASE
-
EXU7IND
-
EXU7USCU
-
EXU81NOS
-
EXU81SPOKI
-
EXU81TTS
-
EXU81USCI
-
EXU8ICO
-
EXU8INK
-
EXU8IXP
-
EXU8OID
-
EXU8POKI
-
EXU8USCU
-
EXU9DOI
-
EXU9IXCP
-
EXU9LBP
-
EXU9LOB
-
EXU9LTTS
-
EXU9NOS
-
INDEX_ORPHANED_ENTRY_V$
-
INDEX_STATS
-
KU$_10_1_IND_STATS_VIEW
-
KU$_10_2_FHTABLE_VIEW
-
KU$_10_2_IND_STATS_VIEW
-
KU$_11_2_IND_STATS_VIEW
-
KU$_2NDTAB_INFO_VIEW
-
KU$_ACPTABLE_VIEW
-
KU$_ALL_INDEX_VIEW
-
KU$_DOMIDX_OBJNUM_VIEW
-
KU$_DOMIDX_PLSQL_VIEW
-
KU$_EQNTABLE_DATA_VIEW
-
KU$_FHTABLE_VIEW
-
KU$_FIND_SGC_VIEW
-
KU$_HTABLE_DATA_VIEW
-
KU$_HTABLE_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_HTSPART_DATA_VIEW
-
KU$_INDEX_COL_VIEW
-
KU$_IND_EXISTS_VIEW
-
KU$_IND_PARTOBJ_VIEW
-
KU$_IND_PART_COL_VIEW
-
KU$_IND_PART_VIEW
-
KU$_IND_STATS_VIEW
-
KU$_IND_SUBNAME_VIEW
-
KU$_IND_SUBPART_COL_VIEW
-
KU$_IND_SUBPART_VIEW
-
KU$_IONT_VIEW
-
KU$_IOTABLE_BYTES_ALLOC_VIEW
-
KU$_IOTABLE_DATA_VIEW
-
KU$_IOTABLE_VIEW
-
KU$_IOTPART_BYTES_ALLOC_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_IOT_PARTOBJ_VIEW
-
KU$_LOBINDEX_VIEW
-
KU$_M_VIEW_FH_VIEW
-
KU$_M_VIEW_H_VIEW
-
KU$_M_VIEW_IOT_VIEW
-
KU$_M_VIEW_PFH_VIEW
-
KU$_M_VIEW_PH_VIEW
-
KU$_M_VIEW_PIOT_VIEW
-
KU$_M_ZONEMAP_FH_VIEW
-
KU$_M_ZONEMAP_H_VIEW
-
KU$_M_ZONEMAP_IOT_VIEW
-
KU$_M_ZONEMAP_PFH_VIEW
-
KU$_M_ZONEMAP_PH_VIEW
-
KU$_M_ZONEMAP_PIOT_VIEW
-
KU$_NIOTABLE_DATA_VIEW
-
KU$_NTABLE_DATA_VIEW
-
KU$_OIDINDEX_VIEW
-
KU$_PFHTABLE_VIEW
-
KU$_PHTABLE_VIEW
-
KU$_PIOTABLE_VIEW
-
KU$_PIOT_PART_VIEW
-
KU$_TAB_SUBNAME_VIEW
-
KU$_TTSP_INDPARTVIEW
-
KU$_TTSP_INDSUBPARTVIEW
-
KU$_TTS_IDXVIEW
-
KU$_TTS_INDPARTVIEW
-
KU$_TTS_INDSUBPARTVIEW
-
KU$_TTS_IND_VIEW
-
KU$_TTS_MV_VIEW
-
KU$_TTS_VIEW
-
KU$_ZM_VIEW_FH_VIEW
-
KU$_ZM_VIEW_H_VIEW
-
KU$_ZM_VIEW_IOT_VIEW
-
KU$_ZM_VIEW_PFH_VIEW
-
KU$_ZM_VIEW_PH_VIEW
-
KU$_ZM_VIEW_PIOT_VIEW
-
LOADER_LOB_INDEX_COL
-
LOGMNR$ALWAYSSUPLOG_PROC
- show dependent code
-
LOGMNR_DICT_CACHE
- show dependent code
-
LOGMNR_KRVRDLUID3
- show dependent code
-
LOGSTDBY_SUPPORT_TAB_11_1
-
LOGSTDBY_SUPPORT_TAB_11_2
-
LOGSTDBY_UNSUPPORT_TAB_11_1
-
LOGSTDBY_UNSUPPORT_TAB_11_2
-
PRVT_ILM
- show dependent code
-
STRADDLING_RS_OBJECTS
-
STRADDLING_TS_OBJECTS
-
SYSSEGOBJ
-
SYS_OBJECTS
-
SYS_UNCOMPRESSED_SEGS
-
TTS_TAB_VIEW
-
USER_INDEXES
-
USER_IND_COLUMNS
-
USER_IND_EXPRESSIONS
-
USER_IND_PARTITIONS
-
USER_IND_PENDING_STATS
-
USER_IND_STATISTICS
-
USER_IND_SUBPARTITIONS
-
USER_OBJECTS
-
USER_OBJECTS_AE
-
USER_OBJECT_USAGE
-
USER_PART_INDEXES
-
USER_PART_KEY_COLUMNS
-
USER_SUBPART_KEY_COLUMNS
-
USER_XML_INDEXES
-
_DBA_STREAMS_UNSUPPORTED_9_2
-
_user_stat
-
_utl$_gnp_ind
-
_utl$_gp_ind_parts
-
_utl$_lc_ind_subs
-
_utl$_lnc_ind_parts